I have a database that we use to keep up with employees who are delinquent in their training. I am not concerned with MM/DD/YY format to extract people. I want Month only. Our fiscal years runs from Oct to Sept. I want people from 11 (Nov) to 5 (May) to print on my report. Currently, the query is pulling from 5 to 11.
Is there a way to make it work the way I need it?

Please help!

Deborah

You'd need to include the year to get the order the way you want. You could go from 11/1/2003 to 5/31/2004

Well, I can't. You see we are trying to get the ones that have missed their training. An example could include someone who should have can in 11/01/2002 and someone who should have came in 11/01/2000. I want all the people who should have came to class in their hire date month based on our fiscal year.

Is there any hope?

Deborah

You could use the Month Function which will give a numeral value for your date based on the month.
ie: = Month(#11/24/2004#) yields 11.

Then in the criteria of your query you could just list the numbers of the months you want.

I quess to get 11 to 5, you'll have to add a zMonth column: DatePart("m", [DateField]) and set the criteria
11
12
1
2
3
4
5