Using hours in a date range parameter

[Doug1962]

I would like to run a query every date to extract only the records that
have been added to the database within my criteria for a 24 hour
period. I.E. I would like the query to extract records from 3:30 pm
yesterday to 3:30 pm today. The query is automated to run at 3:30
everyday. I am unsure of hour to express hours in my date field
parameter.

Thanks in advance!!!

Doug in Tallahassee

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Something like:

SELECT * FROM table_name
WHERE date_time_colum n Between DateAdd("h", -24, Date() + #1530#) And
Date() + #1530#

1530 = 3:30 PM.

Between expression translates to "24 hrs before today at 3:30PM and
today at 3:30PM."

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQf/n84echKqOuFEgEQ IzmgCgwbnXm1vDI A9HGLvXHUx6Xx+L seYAn3ql
Y8EI8rHeOzpqi3a lDHGilzV9
=dJ2J
-----END PGP SIGNATURE-----
Doug1962 wrote:

I would like to run a query every date to extract only the records that
have been added to the database within my criteria for a 24 hour
period. I.E. I would like the query to extract records from 3:30 pm
yesterday to 3:30 pm today. The query is automated to run at 3:30
everyday. I am unsure of hour to express hours in my date field
parameter.

[Geoff]

Criterion for date field:

=DateAdd("d" ,-1,Date()+TimeVa lue("13:30")) And

<Date()+TimeVal ue("13:29:59")

DateAdd gives yesterday's date because its second param (-1)
subtracts one day ("d" first param) from today's date (Date())
at 13:30 pm.

Geoff