View Full Version : suppress duplicate headers


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?

llkhoutx
09-08-2006, 08:34 PM
Put the Hour and the Time controls in the same report section and horizontally aligned.