Another Query question

[drsalvas]

Please bear with my ignorace, I am new to the system.

On my table, I have a column with the format mm/dd/yyyy 00:00:00 PM.

I am querying on this column to find certain records, IE after a certain hour and I am using >#00:00:00 PM# format to get those records.

Now I need to be able to pull up all records BETWEEN times.

For example if I have records:
12/01/2002 12:00:00 PM
12/02/2002 01:00:00 PM
12/03/2002 01:15:00 PM

And I need to find all records for the month of December (all records in the table with be from that Month)between 12:00 PM and 2:00 PM, how would I setup that criteria in the query??

Thanks for your help.

Dan

 

[Russell Hauf]

Hi Dan,

In the criteria part of one of your fields put something like this:

Month([dt1])="12" And Year([dt1])="2002" And Hour([dt1]) Between "12" and "14"

replace dt1 with the name of your date/time field.

So the Month is December (12) and the year is 2002 and the hour is between noon (12th hour) and 2pm (14th hour).

Make sense? You can put this in the criteria section for any field that's in your query.

Hope this helps - let us know if it does not,

Russell