grnzbra
09-08-2006, 02:51 PM
I am using Office 2003
I have a table that records time useres log in. I would like to create a report that shows the log ins by hour with a count for each hour. It should look something like this
11
11:00 UserA
11:22 UserB
Total Logins: 2
12
12:35 UserC
Total Logins: 1
Seems to me that this should be easy, but even following the help file for supression of duplicates in grouped reports, the best I seem to be able to get is
11 11:00 UserA
....11:22 UserB (The periods here are just place holders so this formats right.
12 12:35 UserC
If either the header or footer doesn't have a height of 0, the duplicate hour field is repeated.
I could swear that I did this all the time in Office 2000. What's the difference?
I have a table that records time useres log in. I would like to create a report that shows the log ins by hour with a count for each hour. It should look something like this
11
11:00 UserA
11:22 UserB
Total Logins: 2
12
12:35 UserC
Total Logins: 1
Seems to me that this should be easy, but even following the help file for supression of duplicates in grouped reports, the best I seem to be able to get is
11 11:00 UserA
....11:22 UserB (The periods here are just place holders so this formats right.
12 12:35 UserC
If either the header or footer doesn't have a height of 0, the duplicate hour field is repeated.
I could swear that I did this all the time in Office 2000. What's the difference?