newbie: criteris on month(4)?

  • Thread starter Thread starter Bill Parker
  • Start date Start date
B

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
 
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.
 
ta! Much easier than I expected. Thanks.


George Papadopoulos said:
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.
Click to expand...
 
Back
Top