Re: Need Help Summing Sales and Donations in Report Footer

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


"znibk" <znibk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote

I am trying to get a Grand Deposit Total of Sales,
Cash Donations, Other Income, and Other Sales in
the report footer. I have tried adding a new field in
the query and referencing that field name in the
report footer ie: AGDT. I used the sum in the
Total Row of the Query

What "Total Row" of what Query?

and put Nz([ASalesDep],0)+Nz([CD],0)+Nz([OI],0)+
Nz([OS],0) and I get a blank return when I run the query.
As I said before, I have tried putting just the field name
[AGDT] in the report footer and I have tried putting that same
expression in the report footer, and also receive a blank
spot on my report.

If the calculation you used to create [AGDT] does not contain a value, why
would you expect that putting the Field in the Control Source of a Control
_anywhere_ on the report to show anything?

Anyone, any suggetions? As always, your help
is appreciated. k

This seems to be our day in m.p.a.reports to be expected to correct errors
without any description of the underlying data. Tell us what data you have,
how it's structured, and what you have in the report (e.g., the parts that
are working)... oh, yes, copy and past the SQL for the Query that is the
RecordSource of the Report, too. Then maybe someone will have a remote
chance of making a useful suggestion.

Larry Linson
Microsoft Access MVP


.

Relevant Pages

  • Re: Building Expression in Query
    ... you should be able to enter something like the following in a field "cell" in the query. ... In my query I am looking to write an expression that performs mathematical calculations between 3 tables/queries which are listed in this combination query. ... I want to call the field "Margin" and I want it to make the following calculation: ... This is populated on my report footer as a subreport because I couldn't figure out how to do the calculations with the Margin appearing in the Report Footer section when I needed some informatin that resides in the Detail section of the report in the calculation. ...
    (microsoft.public.access.queries)
  • Re: Grand Totals
    ... No, if you have a HaulingCost field and a LaborCharge field in your query, ... > report footer and that would calculate everything? ... The control source for a calculated value ...
    (microsoft.public.access.reports)
  • Re: Grand Total of Time in Report Footer not working
    ... Don't format TotalTime in the query. ... > I then have a Grand Total in the Report Footer which totals all the ...
    (microsoft.public.access.reports)
  • Re: Calculated Fields in Reports
    ... >report footer that breaks down the number of clients by ... Base the the new report on a Totals type query. ... FROM clients INNER JOIN AgeGroups ...
    (microsoft.public.access.reports)
  • RE: diplaying contents of required date and also the sum of contents
    ... Use that query as the basis for a report. ... You can then have the totals show ... at the bottom of the report footer or group footer. ... I want to display contents as per required date along with the sum at bottom ...
    (microsoft.public.access.queries)