write the criteria in a query to specify info in a date/time fld.

[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

 

[scking]

Between [enter a beginning date] And [enter a end date]

Would work in a parameterized query. If that is what you mean.

Steve King Growth follows a healthy professional curiosity