I have a Flat file with Employee Name, Class1 Date, Class2 Date & Class3 Date.
What I am trying to do is get a Spreadsheet looking report with Dates across the top and using a query for a date Range.
For Example: Show ALL Classes >= 05-01-2006 and <= 05-23-2006 I put in one Employee with: Class1 Date = 05-05-2006 Class2 Date = 04-10-2006 Class3 Date = 05-10-2006 I put >= #05-01-2006# and <= #05-23-2006 on a different line for each of the date fields in a Query. However the Query ALWAYS picks ALL THREE Dates even though the Class2 Date simply does NOT MEET the Criteria. What am I doing wrong? How can I get the correct answer? I would gladly Email you this tiny MDB file if you wish... Alan NYC ABRAMOWITZA@coned.com
