Access Report

[Guest]

I have a basic invoice form where the individual line items are summed and
freight added to give a total. I want to create a summary report of many
invoices, but have a problem in getting a grand total as I can't get a
correct sum of the shipping costs. For example using =Sum([Freight]) does
not work. Neither does simply placing the Freight control in the report
footer.
In other words, I only want to get the one freight cost associated with
each invoice to sum correctly. The Northwind Database doesn't help. Is
there a simple solutionfor this?

 

[Marshall Barton]

I have a basic invoice form where the individual line items are summed and
freight added to give a total. I want to create a summary report of many
invoices, but have a problem in getting a grand total as I can't get a
correct sum of the shipping costs. For example using =Sum([Freight]) does
not work. Neither does simply placing the Freight control in the report
footer.
In other words, I only want to get the one freight cost associated with
each invoice to sum correctly.

Add an invisible text box named txtRunTotal next to the
invoice total text box (in the invoice group footer
section?). Set its control source expression to
=invoicetotaltextbox
and set its RunningSum property to Over All.

Now, your report footer text box can display the grand total
of all invoices by using the expression =txtRunTotal

 

[Guest]

Marshall,
Fantastic. It works perfectly. Thank you, Thank you, Thank you. I was
really stuck and spinning my wheels. Certainly not an intuitive process.

Bill LeValley

I have a basic invoice form where the individual line items are summed and
freight added to give a total. I want to create a summary report of many
invoices, but have a problem in getting a grand total as I can't get a
correct sum of the shipping costs. For example using =Sum([Freight]) does
not work. Neither does simply placing the Freight control in the report
footer.
In other words, I only want to get the one freight cost associated with
each invoice to sum correctly.

Add an invisible text box named txtRunTotal next to the
invoice total text box (in the invoice group footer
section?). Set its control source expression to
=invoicetotaltextbox
and set its RunningSum property to Over All.

Now, your report footer text box can display the grand total
of all invoices by using the expression =txtRunTotal