addition of fields

  • Thread starter Thread starter jkjmwilliams
  • Start date Start date
J

jkjmwilliams

I have a report with AmountDue and AmountDue2. How can I add these two
amounts together for a grand total at the end of the report? Here's my syntax
for getting the total for Amount Due"

=DSum("AmountDue","[SECU]")
 
?and the formula/expression for "AmountDue2"?

In a control in the Report Footer section, in the Control Source, use
something like (untested):
=DSum("AmountDue","[SECU]") + .... {whatever expression you use to
calculate AmountDue2}


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I've already tried that. I used this expression:

=DSum("AmountDue","[SECU]")+("AmountDue2","[SECU]")

and that didn't work either. I can get one or the other to give me the
correct sum, but how do I add the two sums together?

Jeff Boyce said:
?and the formula/expression for "AmountDue2"?

In a control in the Report Footer section, in the Control Source, use
something like (untested):
=DSum("AmountDue","[SECU]") + .... {whatever expression you use to
calculate AmountDue2}


Regards

Jeff Boyce
Microsoft Office/Access MVP


jkjmwilliams said:
I have a report with AmountDue and AmountDue2. How can I add these two
amounts together for a grand total at the end of the report? Here's my
syntax
for getting the total for Amount Due"

=DSum("AmountDue","[SECU]")
Click to expand...
Click to expand...
 
I've already tried that. I used this expression:

=DSum("AmountDue","[SECU]")+("AmountDue2","[SECU]")

and that didn't work either. I can get one or the other to give me the
correct sum, but how do I add the two sums together?

Jeff Boyce said:
?and the formula/expression for "AmountDue2"?

In a control in the Report Footer section, in the Control Source, use
something like (untested):
=DSum("AmountDue","[SECU]") + .... {whatever expression you use to
calculate AmountDue2}

Regards

Jeff Boyce
Microsoft Office/Access MVP

jkjmwilliams said:
I have a report with AmountDue and AmountDue2. How can I add these two
amounts together for a grand total at the end of the report? Here's my
syntax
for getting the total for Amount Due"

=DSum("AmountDue","[SECU]")
Click to expand...
Click to expand...
Click to expand...

=DSum("AmountDue","[SECU]") + DSum("AmountDue2","[SECU]")

The above sums the values of the 2 fields in the table, which may, or
may not be, the same as the values shown in your report if the report
has been filtered.
 
As Fred points out, that should work.

But it will depend on what values you have in the ?query/?table named
[SECU].

What happens when you try this? "It didn't work" doesn't provide much to go
on...

Regards

Jeff Boyce
Microsoft Office/Access MVP

jkjmwilliams said:
I've already tried that. I used this expression:

=DSum("AmountDue","[SECU]")+("AmountDue2","[SECU]")

and that didn't work either. I can get one or the other to give me the
correct sum, but how do I add the two sums together?

Jeff Boyce said:
?and the formula/expression for "AmountDue2"?

In a control in the Report Footer section, in the Control Source, use
something like (untested):
=DSum("AmountDue","[SECU]") + .... {whatever expression you use to
calculate AmountDue2}


Regards

Jeff Boyce
Microsoft Office/Access MVP


jkjmwilliams said:
I have a report with AmountDue and AmountDue2. How can I add these two
amounts together for a grand total at the end of the report? Here's my
syntax
for getting the total for Amount Due"

=DSum("AmountDue","[SECU]")
Click to expand...
Click to expand...
Click to expand...
 
Back
Top