Report is adding too many numbers

[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,

 

[Duane Hookom]

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.

 

[Jacques]

Too add to the below, my query is what's making extra records (and I don't
know why)..