Query to calc. every six months

[losthome]

Hi there,

I have employee data that includes a start date, personal info, ect. I need to have a qeury to calculate and filter people for the employee's six month review's from there start date, and then six months from their last review.

I don't have a clue on how do go about doing this! Any help would greatly be appreciated.

Thank you,

Jennifer

 

[CJBIRKIN]

If I understand you correctly what you are asking is to know when people are going to have to attend a review meeting and you would like to know in advance.

To do this you can use the date add function in a query

add a field to a query and enter the following

sixmonthreview: dateadd("m",6,[startdate])

if you want to know six months in advance then use 6, three months in advance use 3.

The function adds the number selected to the date in the field for days use "d" months "m" years "y"

then in the criteria add this: [Meeting date] When you run the query it will ask you to select a date and return all the people due for a meeting on that date.

To do this for dates after the last review you'll need to add a field in your table to record the date they went to their meeting. You can then do the same query as above.

If i've got the wrong idea feel free to shout.

Chris