Jun 15 2004, 02:02 PM
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?
Jun 15 2004, 02:09 PM
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
Jun 15 2004, 02:14 PM
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?
Jun 15 2004, 03:10 PM
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.
Jun 15 2004, 07:10 PM
I quess to get 11 to 5, you'll have to add a zMonth column: DatePart("m", [DateField]) and set the criteria
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here