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
|
|||
|
|||
Sum a value in a group header
Hi guys
I have a report using a query which gives me duplicate rows in the details section (well almost duplicate - they are duplicate except for one field. For example, I have a table of incidents with an Amount field but there may be many people attached to that incident. When I retrieve all data around that incident including the people attached I get one row for each person attached to the incident. All data is duplicate except for the persons name. So what I did was group by the incident number and put the data in the group header, which worked fine. I hide the detail and only see one row per Incident. My problem now is that I need to sum the Amount field and Count the records in the group header..not the detail. I have tried to do this in the group footer but it seems to reference the Amounts in the detail (which is hidden). So instead of getting a total of say $5,000 I will get $15,000 (assuming there are three rows for the same incident). How can I calculate the value of the Amounts in the group header and also Count the rows in the group header? Thanks...Andy |
Thread Tools | |
Display Modes | |
|
|