Puzzled by Query Results

[Guest]

Hello:

I am building a typical Many to Many application for our training classes.
One of the tables in the design is called tblClasses. We have over 100
classes in the table and about half of them were scheduled in July. When
we're registering students for new classes, obviously we don't need nor want
to see any classes from the past.

I therefore added a criteria to the [Class_Date] field in the query, which
is the 4th or 5th field in the query. The criteria is: >Date()

I thought that would eliminate all classes before today's date and also show
ALL classes starting today or in the future. The criteria does eliminate all
classes scheduled before today's date. However, the query only displays 8
classes and I know there are approximately another 40 classes scheduled after
today in late August and September. Do you know why the query is showing
only 8 classes when it should display close to 50 records?

Thanks,
Robert

 

[Guest]

Please disregard this question!!!

I just went into the design of tblClasses and noted that someone changed it
from a Date/Time field to a text field. I changed it back to a date field and
the query now works perfectly.

Sorry about that,
Robert