addition of fields

[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]")

 

[Jeff Boyce]

?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]

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?

?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 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]")

 

[fredg]

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?

?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 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]")

=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.

 

[Jeff Boyce]

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

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?

?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 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]")