query using two dates and time range

[sumukhreddy]

hi All,



first of all i would like to say thank you for your kind help for my previous problems.

i need one more suggestion. i need to pull data from table, where the data needs to be limited to be inbetween a specific range of dates and times like, say ill need to see only those records that were entered sometime between 23-Mar-2016 3:00am to 24-Mar-2016 3:00am. (I work overnights, so i start on monday and go hometuesday for example). in the database i have 2 columns, both are set todate/time, one column currently holds just the date, and one holds just thetime. I tried as below:

In query i've add a calculated field and then search against that
Field: [SUB Date] + [SUB Time]
Criteria: Between #DATE()-1 3:00AM # and #DATE() 3:00am#

but i'm getting syntax error. please help me

[ranman256]

Between forms!frmMyForm!txtStartDate and forms!frmMyForm!txtEndDate

on the form enter the dates into the boxes. Time too.
if you want separate boxes ,combine the 2 boxes into the final one...
TxtStartDate = txtStart1 & " " & txtTime1
...

[CJ_London]

double posting here already answered

http://www.access-programmers.co.uk/...d.php?t=285565

@sumukhreaddy - please read this thread

http://www.excelguru.ca/content.php?184