Report is adding too many numbers

  • Thread starter Thread starter Jacques
  • Start date Start date
J

Jacques

Hello all,
I've got a problem with Sum Totals at the end of a report, but I'm unclear
if the issue can be resolved in the query or the report.

I have two tables, A and B. A has a one-to-many relationship with B, but
not every record in A has corresponding records in B.

My query has A and B in it and the relationship there states to Include ALL
records from A and only records from B that are equal. This is giving me
every record in both A and B.

My problem is that, a field in A holds Currency, and some records in A have
the same $ amount. B holds several currency fields as well.

In the corresponding report, the grand total in the report footer is giving
me a sum that's way larger that if I summed all the records in the table by
hand (coping the whole $ amount field from the table into Excel sums to a
smaller number, which is correct).

If I generate a report for just table A and not show table B the grand total
in that report footer is correct.

How do I get the report or query to give me all the info, but not sum extra
$ amounts that it is creating out of thin air?


Thanks beforehand,
 
At least one reply in the Report news group where you asked the same exact
question. Please keep your questions to a single news group.
 
Back
Top