printing report showing a range of time

C

Chase

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.
 
J

John Spencer

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
 

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

Page numbering with Merged Document and IF statements 1
Space at end of multi page list to accommodate new entries 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
VBA word change keys 0
Printing a Range Of Records Using A Button 1
Report printing multiple pages based on query 2

Top