Duplicates and Sums

[iftaman]

I tried to look through the previous answers, but it seems like more
things are geared toward reports and hiding individual fields. This is
for a government agency. I have set up a mail merge document for a
billing letter. The fields work well, the letters are correct, and the
reports are all formatted correctly (finally!). However, I have found
out that the data entry people have to create separate letters for each
corporate officer, with the amounts and other data being the same (only
the corp ofc name and address changes). Since this is a small pc-based
application being used by folks not trained in Access, I was hoping to
keep this as simple as possible. I know one option that I have is to
just create a separate Word template they can use that will not capture
the data into the database. However, what I would ideally like to do
is allow them to enter all of the data on the normal mail merge
document, so that we can track the correct number of letters going out
(for performance evaluation purposes). I based my reports on a query.
Since I don't need the names of those assessed in the reports I
created, all of the data in the query is going to be duplicated (tax
type, registration #, tax, penalty, and interest). I know I can go
into the various reports and select the control and tell it to hide,
but that would just hide the control (registration #), but I know it
would keep showing the rest of the record, and the summary reports
would continue to sum each record. What I would like to do is put the
record in the table, but only display, and count/sum for statistical
purposes, one instance of each record. Thanks in advance for any help
you can give me.