I am very new to access so thank you in advance for your help and patience.

I have creadted a database for tracking students.

I would like to give them progress reports every three month based on thier start date (I have a 'short date' field for the start date).

If I run the query in January I would like results for all student who started in Jan, April, July & Aug.

Thank you again!

Just for the record, here's how Access stores a DateTime field. "ShortDate" is simply a display option. Storing, Calculating, and Comparing Date/Time Data (http://http://support.microsoft.com/default.aspx/kb/q130514/) As for your issue, the student start dates seem inconsistant. How would *you* pick them out?

When a student enrolls they are given a start date.

I planned to create a sperate query for each month that would give me a list of students that need progress report that month based on 3 month intervals from their start date.

I am I making any sence?

Maybe you will find this link (http://www.pacificdb.com.au/MVP/Code/Dates.htm) useful. Post back if you need additional assistance.

Thank you but no page diaplays.

I fixed the link.

Got it!

Thanks.

I will see if I can make sence of this :)