Sum on Report (1 Viewer)

[DanG]

The query has a 2 tables, one called tblMSR and it contains a field called "MailListSize" and the other table is a detail table called tblCampaigns.

if the detail table only has one item then of course the "MialListSize" shows onece, but if the detail table has 2 records in it then the "MailListSize" show up twice.

My problem is that I sum the "MailListSize" in my report in the footter section and when there is one detail item I get the result I want, but when there is more than one detail item the "MailListSize" gets counted for each detail item listed (which is not what I want).

Any ideas would be great!

 

[boblarson]

That's where the Sorting and Grouping (particularly the Grouping) part comes in handy. If you have a group of MailListSize then you can get a sum for the group in the group footer.

 

[DanG]

Worked like charm!

Thank you