View Single Post
  #3 (permalink)  
Old January 4th, 2006, 10:58 AM
dbartelt dbartelt is offline
Authorized User
Join Date: Apr 2005
Location: , , USA.
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts

Thank you for your reply. I tried what you suggested and I receive a parameter box “txt0-30Days” when I open the report. The text boxes I am trying to sum are calculated fields and are not in any table. They are calculated off of the InvoiceDate. I group the report by CustomerName & CustomerID. What I need to do is sum each text box type separately.

I have tried =Sum(Nz([0-30Days])). This control shows $0.00 as the result.
I then tried =Nz([0-30Days]). This control shows the amount only for the last record in each group.

Customer A
                               [u]0-30Days</u> [u]31-60Days</u> [u]61-90Days</u> [u]Over90Days</u>
Invoice 1 $25.00
Invoice 2 $36.00
Invoice 3 $72.00

=Sum(Nz([0-30Days])) results $0.00
=Nz([0-30Days]) results $72.00


Customer B
                             [u]0-30Days</u> [u]31-60Days</u> [u]61-90Days</u> [u]Over90Days</u>
Invoice 1 $18.00
Invoice 2 $65.00
Invoice 3 $53.00

=Sum(Nz([0-30Days])) results $0.00
=Nz([0-30Days]) results $53.00

=Sum([0-30Days]) results in the same type of parameter box as =Sum([txt0-30Days]) when the report is opened.

Do I need to create a new text box for running totals for each of the calculated text boxes?

I’m confused!!!!!!

D. Bartelt
Reply With Quote