Re: Report is making too many numbers

Tech-Archive recommends: Speed Up your PC by fixing your registry

Is it possible to Sum a Text box in a report. I've only been able to use
Sum on a query or table name outside of a report. It would probably be fine
if I could make a text box Sum another text box by the text box name.



"Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx> wrote in message
news:uNspN5HOGHA.3144@xxxxxxxxxxxxxxxxxxxxxxx
I expect it's the fields from A that are too high. If A has a record with a
value of $10 and there are 3 related/child records in B then you are
probably totaling this field to $30. This makes sense.

You can place the fields from A in a group header. Assuming the field is
[Shipping] create a text box like:
Name: txtShippingRunSum
Control Source: [Shipping]
Running Sum: Over All
Visible: No

Then add a text box to your report footer:
Control Source: =txtShippingRunSum

--
Duane Hookom
MS Access MVP
--

"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: Tips on domain aggregate replacements
    ... My initial thinking would be to use a query that SELECTS the records to be totaled, loops through them getting the SUMS, and then store the data in a temporary table that is then used for the final report. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months and present these as fields on each line of the report. ... Month1Total -> DSum (blah, blah, blah where date is within next month from today ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report is making too many numbers
    ... My report is based on a query. ... I put the running sum text box in there. ... My report is grouped by Vendor, then Project, ... I've got a problem with Sum Totals at the end of a report, ...
    (microsoft.public.access.reports)
  • Re: Generate such a report
    ... The balances appearing in report are as ... How do I add a sum to a query you've made for me? ... payables in a table called "Settlements". ... Receivable By, Receivable From, and Amount. ...
    (microsoft.public.access.formscoding)
  • Re: How to calculate column total
    ... should be in the query unless you are grouping on another field. ... You can sum a field on a form or report by creating a textbox control on the ...
    (microsoft.public.access.gettingstarted)