Hello all

I am new to Access so pardon my ignorance. I have an access database that has employee name, address, date of hire, work location, date of termination and reason for leaving. Current employees have no value on date of termination and employees that have left have a date value on date of termination. I am trying to create two reports:

1 -> tells me the the number of terminations (count of) for the last 13 months from the month the report is started e.g. if the report was started today then it would look something like:

April 2006 | May 2006 | June 2006 | ... | May 2007
5 14 11 3

2 -> tells me the number of emplyees that left within 30 days from date of hire, between 30-90 days, between 90-365 day and after 365 days e.g.

Within 30 Days | 30-90 Days | ... | After 365 Days
5 10 22

How do I do it? Is it possible? Any help is greatly appreciated. Thank you very much.

you need to use the DateAdd Function

to Retrieve all records for the last month would be something like this

WHERE [YourTableDate] BETWEEN DateAdd("m",-1,Date()) AND Date()