Date time combined query

  • Thread starter Thread starter Desperate Wes
  • Start date Start date
D

Desperate Wes

I need to pull all records out of a main table from a beginning date at a
certain time.... till a ending date at a cerain time. please help
 
Do you have significant table and field names that you can share? I always
recommend creating a form with controls that allow users to enter or select
criteria values that can be used to filter a query, form, or report.
 
On Fri, 11 Jan 2008 04:00:01 -0800, Desperate Wes <Desperate
I need to pull all records out of a main table from a beginning date at a
certain time.... till a ending date at a cerain time. please help

Try something like this:

SELECT * from MyTable WHERE MyDateTime BETWEEN #1/1/2006 08:00# AND
#1/31/2006 15:00#"

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top