Good morning,

I created the employee database and used a query to calculate and show years of service in each time e.g. 1/1/2000 to 1/1/2002 = 2 years + 6/30/2015 to 6/30/2022 = 7 years so total years of service is 9 years (I use multiple resources to come up with the calculation).

Since an employee can be rehired several times, all the years of service must be counted.
I also want the access to show current active/inactive, I integrated "hide inactive customer" knowledge. However, when I click Active/InActive/All in the form footer, the year of service query shown #Name?
The query used in calculating years of service has no issue if you do not click Active/Inactive/All in the form footer.

What did I do wrong?
PS. I want to attach the picture but under "Start a NEW Conversation" does not have upload images button.

Thank you