Access Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
murrwheel said:
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.
Click to expand...

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

Marshall Barton said:
murrwheel said:
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.
Click to expand...

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
Click to expand...
 
Back
Top