One more Qry six month question

[losthome]

Hi There Again,

Just one last question, I have set up my query to look up every six months. Then I append that date to a history table. then I need it to look at the Last Review date field. Can I still have the following in the StartDate (when the employee started with the company) and have it do Either Or for the Start Date field or Last Review Date field. What ever was done last. This way it still picks up the people would haven't had a first 6 month review yet.

Start Date Field.
6 month review: DateAdd("m",6,[EmployeeStartDate])

Last Review Date Field
????

I hope this makes sense. Please Help

 

[CJBIRKIN]

Hello again
you could use an if statement
iif([last review date]>[EmployeeStartDate], DateAdd("m",6,[last review date]) , DateAdd("m",6,[EmployeeStartDate]))

hope this helps
Chris