write a query to find date and time.

[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.

 

[BanditWk]

Set the Expression to be as such:

Expr1: Format([NameOfTimeStamp],"mm/dd/yyyy&quot

and the Criteria as such:
Criteria: = #06/11/2002#

This should produce the desired results.
Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

 

[Guest_imported]

Hi Roy,
Unless I did something wrong still was unable to get this correct info.

 

[jioek]

use like #06/11/2002# & "*" or like *06/11/2002*