Query criteria with specific date and time

[Senate]

Hello

I'm looking for a way to only get records in a query which are made between yesterday 07:00 and today 07:00.
The query contains a table where the date and the time of the recordset are given like 08/02/18 15:02:00 and I tried the criteria
Between Date()-1 #07:00:00# And Date() #07:00:00#
But it seems there is a syntax problem but I can't see where.

Can please someone help me?

[ranman256]

you do date math with DateAdd, or DateDiff.
put a textbox on a form with the dateTime you want and the query would be:

Between DateAdd("d", -1 ,forms!myForm!txtDate) and forms!myForm!txtDate

or use VB sql:
vDat = date() & " 7:00 am"
vDat2 = DateAdd("d", -1 , vDat )
ssQl = "select * from table where [dateFld ] Between #" & vDat2 & "# and #" & vDat & "#"