calculated fields in a Report

[Michael and Fayann]

I created a report off of a query. The parameter is ID number.
On the form that I entered the data is a subform that has a list of names
and check amounts (as in checking account).
When I run a report, for each name entered on my form, I get two reports.
For example, if I had six (6) people who gave me a check, I would get a
total of 12 reports with one name on each report, listed twice. I would
like to have all the names listed on the report with a total. Can you help
me?

 

[Fons Ponsioen]

I suspect you may have placed the subreport in the detail
band of your report. Iyou put it in the group footer the
duplication may be eliminated.
Other possibilities are that the query allows for
duplication. This can be tricky at times, depending on
how complex the query is. You can however set the
properties for the query to allow only unique values.
Hopes this helps.
Fons