Re: Report is making too many numbers

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


"Jacques" <Jacques Latoison at hotmail dot com> wrote in message
news:OyItJxHOGHA.1124@xxxxxxxxxxxxxxxxxxxxxxx
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,





.

Relevant Pages

  • Re: Report is making too many numbers
    ... from the $'s being listed more than once in the query. ... And you want to display the sum of in the Vendor header or footer ... My report is based on a query. ... those records--you could create a Totals query by depressing the ...
    (microsoft.public.access.reports)
  • Re: Report is making too many numbers
    ... the sql view and name of your totals query ... number from the $'s being listed more than once in the query. ... Assuming you have groups in your report like ... And you want to display the sum of in the Vendor header or footer ...
    (microsoft.public.access.reports)
  • Re: Report is making too many numbers
    ... My report is grouped by Vendor, then Project, ... source query before putting it in the report so every record shows). ... A Running Sum text box accumlates its total. ... I've got a problem with Sum Totals at the end of a report, ...
    (microsoft.public.access.reports)
  • Re: Report is making too many numbers
    ... My report is grouped by Vendor, then Project, ... source query before putting it in the report so every record shows). ... A Running Sum text box accumlates its total. ... I've got a problem with Sum Totals at the end of a report, ...
    (microsoft.public.access.reports)
  • Re: Report is adding too many numbers
    ... my query is what's making extra records (and I don't ... I've got a problem with Sum Totals at the end of a report, ...
    (microsoft.public.access.queries)