help with writing as query to extract date and time data

[Guest_imported]

Any help would be great.

I am writing a query that will extract some data. My problem is one of the fields is setup as a time field. It has data in the one field like this.
( 6/11/2002 11:00:00 PM )

I am trying to get the data for the entire day. If I enter
#6/11/2002#
I will only the data that occurred exactly at that time.
I would not get data that begins at:

( 6/11/2002 12:00:01 AM ) and on.

Please help with some function criteria.

 

[jdegeorge]

Hi:

If you have century on (displaying a 4-digit year), you can use the LEFT function in your query to extract only the date:

Expr2: Left([DateField],10)

In your example, the result would be 06/11/2002.

Hope this helps.

Jim "Get it right the first time, that's the main thing..."