Report Total

[jimd1768]

I have 3 columns in my Report:

AmountDue
AmountOutstanding
Total

I have put in a Sum for the first 2 columns but it won't let me do the same for the Total column.

I want to either have a total of the total column or add the totals of AmountDue + AmountOutstanding.

Thank you in advance. I am using Access 2007

 

[vbaInet]

Use the Expression Builder and in there look for the two controls. Set it as the control source for Total.

You would also need the Nz() function for AmountDue and AmountOutstanding. You wouldn't need it for Total because that's already handled above. Look that up.

 

[jimd1768]

Thank you for the response.

I forgot to mention, I am very new with Aceess and I don't fully understand what you mean with your reply (sorry).

If you could help me in more simple terms, I would be very grateful.

Thanks

 

[Rich]

Add an unbound textbox, set its control source to
=Sum([AmountDue]+[AmountOutstanding])

 

[jimd1768]

Rich, Thank you so much.

Regards

 

[vbaInet]

Remember the Nz if you're likely to have some blank fields.

=Sum(Nz([AmountDue], 0)+Nz([AmountOutstanding], 0))

Have a quick look in the Access Help files for an explanation.

 

[jimd1768]

Thank you.

I have added Nz() to my new book of Access notes.

Thanks for the assistance