T
Terri
In a report, I want to display the highest count of a
group of records. I have the following groups:
Date Grouped on Day then
Time Grouped on Hour then
PortNumber Grouped on Each Value
Detail is blank
In the PortNumber header, I count the number of times each
PortNumber is used (per hour)
I have a "RecordCount" control in the PortNumber group
with a Control Source of =1 and a Running Sum of Over
Group to count the number of PortNumbers used in that hour.
This is all displaying in the Report correctly.
Now what I want to do is in the Date Header, show the
Maximum number of portnumbers used - in other words if the
most portnumbers were used at 2 PM for a given day, that's
the value I want to display in the Date Header.
Any suggestions?
group of records. I have the following groups:
Date Grouped on Day then
Time Grouped on Hour then
PortNumber Grouped on Each Value
Detail is blank
In the PortNumber header, I count the number of times each
PortNumber is used (per hour)
I have a "RecordCount" control in the PortNumber group
with a Control Source of =1 and a Running Sum of Over
Group to count the number of PortNumbers used in that hour.
This is all displaying in the Report correctly.
Now what I want to do is in the Date Header, show the
Maximum number of portnumbers used - in other words if the
most portnumbers were used at 2 PM for a given day, that's
the value I want to display in the Date Header.
Any suggestions?