a Report Spanning 2 days

[dn]

Hi, I have a question, Im using access database to store record. I have
a patrolling table which has the has the "Location No" DateTime
"16/06/2006 00:07:00" , "MachineNo", other table is Location Table
which have "Location No", "Location Desc", "Loc Order".
I managed to generate the Report in this way -Location No-, -location
Desc-, -loc order-, Hour 17-, -Hour 18-,-Hour 23-, etc in the for the
same Date, Is there anyway I can do it with the record spanning 2 days?
i.e. "15/06/2006 To 16/06/2006" the hour will go from -Hour 23-, -Hour
0-, -Hour 1- Because the Schedule of timetable is from 19:00 to 07:00,
Thanks, Hope you are clear about my question.

 

[Guest]

Hi DN - have you tried using the Between [field name] and [field name] -
field name came be existing fields or if you want to enter different dates
each time you run the query try something like - Between [Enter start date]
and [Enter end date] - the text in the [] can be what ever you want.

OR if using absolute dates Between #16/06/2006# and #16/06/2006#
Put it on the criteria line in your query

HTH -- yours Dika