1 criteria 2 places

[Krash878]

Hey all

I have a query that powers a report. I want the query to be based on criteria on a form

the manual criteria is

>=#8/1/2004 12:00:01 AM# And <=#8/31/2004 12:00:01 AM#

I need to get Forms!JobLog!txtDateBegin and Forms!JobLog!txtDateEnd in this criteria. I just want to switch out the dates and keep the times. The text boxes these are refering to are set up as simple dates.

Any Idead

Thanks

Krash

 

[hymn]

Look in help under
Format Property - Date/Time Data Type

Hope this helps
Hymn

 

[Krash878]

I ended up using

>=[forms]![joblog]![txtDateBegin] And <=[forms]![joblog]![txtDateEnd]

Thanks

Krash

 

[randy700]

How about...
BETWEEN forms!joblog!txtDateBegin AND forms!joblog!txtDateEnd


Randy