Sorting by time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table field for the Date/Time Presently it just gives me the totals
for the days selected.

Criteria= Between [Forms]![Time]![From Date] And [Forms]![Time]![To Date]

I would like to change this criteria so it gave me the Totals per hour for
the given time period. Any thoughts?
 
I have a table field for the Date/Time Presently it just gives me the totals
for the days selected.

Criteria= Between [Forms]![Time]![From Date] And [Forms]![Time]![To Date]

I would like to change this criteria so it gave me the Totals per hour for
the given time period. Any thoughts?
Click to expand...

Add a calculated field to your Query

JustTheHour: Hour([datetimefield])

and use it in your Totals query for grouping.

John W. Vinson[MVP]
 
Back
Top