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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
Sorting, Grouping and Calculating in a Query 5
dates 15
Date/Time criteria problem 2
Need Help with Totals Query 24
Querying Dates 5
Date Between Problem after changing table 2
Left Join Question 2

Back
Top