printing report showing a range of time

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

Guest

I want to print a report from a database that lists work done by time.
I would like to print a report that would show a summary for things that
happened between 9 AM and 10 AM (090000 & 100000) and so on. I am stuck.
If there are any suggestions or help I would really appreciate it.
 
Not a lot to go on.

You can get the Hour of a date time field by using the Hour function or by using
the datepart function.

You can group and summarize information in a query. Hint: Open a query and
select View: Total from the menu.

Field: TheHour: Hour([Tablename].[FieldName]
Total: Group By
 
Back
Top