Hi,

just a quick one - in a query i have a few date fields but what i want my criteria to say is give me everything that is in between the following to dates.

Between Today at 9.00 and MyFieldName

Basically i have the myfieldname formatted the way i want but i am trying to work out how to say Today at 9.00 in my criteria?

any ideas?

Hi al0468 -

I think what you are trying to do is qualify your query by setting a date parameter and further by a specific time. Try this code, this should work.

SELECT Table1.FieldName
FROM Table1
WHERE (((Table1.FieldName) Between #9/1/2003 9:0:0# And #9/1/2003 18:0:0#));

This queries table1 on the field fieldname between 9Am on 9/1 and 5Pm on 9/1.

HTH,
Sean

To put the currnt date at 09:00 as a time, you have to remember that dates are actually stored as numbers, not dates, for example, at the time of writing, the current date is 37881 (which is 17 Sept 03) and the current date/time is 37881.7136458333 which to you and me is 17 Sept 03 17:07:39

So you could use the expression:
Date()+0.375

Since Date() is always today's date, and 0.375 is always 09:00, you'll always get the answer you want.

Steven "another swhite" White

I am a loud man with a very large hat. This means I am in charge