If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
group within group reporting
I have a report in which I group event occurences (grouped by time) within
dates grouped and sorted by date. I'd like the format of the report to look like the following using Access2003: monday, 7/6/2009 9AM event 1 data 10AM event 2 data count for monday= 2 Thursday, 7/9/2009 3PM event 3 data 6PM event 4 data count for thursday = 2 Total count for report = 4 I tried every thing I could think of and the best I get is a count of 1 for the daily and a count of 2 for the report . Can anyone help? I've spent an entire day on it. |
#2
|
|||
|
|||
group within group reporting
You need a group footer and a report footer. In the group footer, use an
expression in the controlsource something like: = Count([data]) with [data] being the name of a textbox in the group. Do the same in the Report footer: = Count([data]) or you can Sum the group footer Count controlname in the report footer. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "cyberchoc" wrote in message ... I have a report in which I group event occurences (grouped by time) within dates grouped and sorted by date. I'd like the format of the report to look like the following using Access2003: monday, 7/6/2009 9AM event 1 data 10AM event 2 data count for monday= 2 Thursday, 7/9/2009 3PM event 3 data 6PM event 4 data count for thursday = 2 Total count for report = 4 I tried every thing I could think of and the best I get is a count of 1 for the daily and a count of 2 for the report . Can anyone help? I've spent an entire day on it. |
#3
|
|||
|
|||
group within group reporting
Thank you so much! I will try it as soon as possible. Thanks again!
"cyberchoc" wrote: I have a report in which I group event occurences (grouped by time) within dates grouped and sorted by date. I'd like the format of the report to look like the following using Access2003: monday, 7/6/2009 9AM event 1 data 10AM event 2 data count for monday= 2 Thursday, 7/9/2009 3PM event 3 data 6PM event 4 data count for thursday = 2 Total count for report = 4 I tried every thing I could think of and the best I get is a count of 1 for the daily and a count of 2 for the report . Can anyone help? I've spent an entire day on it. |
Thread Tools | |
Display Modes | |
|
|