newbie: criteris on month(4)?

[Bill Parker]

Hi

I'm trying to set up a query on a table that has a date/time column. I
simply need to view all records for a specified month. Query Design seemed
to be the way to enter it - selecting the columns I'm interested in and
setting a single query on the Time column (the database was imported, so
I've no idea where it got that name from. In table view it seems to be "Time
of Reading" - is there a properties area anywhere for columns?)

I've tried Criteria: month("Time")=4 but it returned nothing.

Hopefully, this is so simple and trivial someone will take pity on me!

Cheers

Bill

 

[George Papadopoulos]

Simply use the criteria row of the query design window. You can set the
value of the time column (> 01/01/2004 And < 30/01/2004) or whatever month
you are interested in.

 

[Bill Parker]

ta! Much easier than I expected. Thanks.

Simply use the criteria row of the query design window. You can set the
value of the time column (> 01/01/2004 And < 30/01/2004) or whatever month
you are interested in.