In order to create a query to schedule a ripple to congratulate colleagues on the anniversary of their start date each year:
Click Access Button
then click HR Admin.
Click Queries then click the + icon.
Select Start Date and Length Of Service.
Click Next and select Start Date.
Click into the drop-down box and set this to Days After Anniversary and input 0.
Select Length Of Service, then click the drop-down box and set this to Does Not Equal.
In the box adjacent to this input 0, then click Next.
Name your query and click Next.
View the results.