setting criteria to get all data from date/time.

[Newatprogramming]

Any help would be great.

I am trying to get info from a date/time field that is setup as ( 6/12/2002 1:15:05 PM )

I set it up like this:

>=[enter a beginning date] and <[enter a end date]

This works fine but I need to narrow it down, and want to set it so that info can be requested and not have to write some function each time I want to use this it.

Another words I want to set it to ask give me all the data

from example ( a date and time through a date and a time )


// 6/11/2002 6:00:00 PM until 6/12/2002 2:30:00 AM

 

[67peshawar294]

Newat,
Create a query selecting all relevant fields.
In the datetime field set the criteria to;
Between [Enter begin date] And [Enter end date]
When you open the query a &quot;Enter Parameter Value&quot; box will appear for the begin, enter a date and press enter another EPV box will appear, enter end date.