I have a hire date field that I need to find out how many days we are into this year against the hire date anniversary date . The idea is to use this information as a parameter for a query to total up vacation days used since the last anniversary date . This way i can show on the vacation request form the days available to the employee when they are completing the form .
What I'm trying to do is after the employee enters their ID number in the form it populates a new record in the vactions table with emlpoyee info from the employees table , Datehire is the field with the hire date , then I need to calculate the anniversary date and pass the anniversary date to the paramter query to sum the records of the current record employee number then display that sum in an unbound text box ?