Grand Total Problem

[Mich2too]

Have created text box called 'Tax Due' to add together the tax and surcharge for each state as needed. Running sum property box for Tax Due is set to Over Group. When I create a text box in the report footer using =Sum([Tax Due])in Control Source it is not finding the Tax Due text boxes. Suggestions???? I have already tried to do all of my calcs in a query, but due to some fields being zero, this is not a viable option.

Thanks in advance!!

 

[GoDawgs]

No answer for the report...but in the query if you put NZ before the field names when adding fields then it will count null fields as 0...so you should be able to have the correct calculation in the query. Hope that helps.

Kevin

 

[CosmoKramer]

Since you already have the RunningSum property set, try just:

=[Tax Due]

as your control source instead...

 

[CTOROCK]

I don't understand why you it can't find it in the report. If it's there it it's there. Are you sure it is in the query. The Nz function will solve the null problems in the query though. "The greatest risk, is not taking one."

 

[Mich2too]

Thanks everyone....got it working!!

 

[Mich2too]

The problem with the query calcs is that I'm multiplying by zero which causes Errors in the results field.

Anyways, changed the text box for the total to equal the amount shown in "Tax Due" box. This gave me the last running total amount shown as the grand total. Then I set the text property of the "Tax Due" box to white to hide the numbers. Hey....not the cleanest simplest way of doing...but got it.

BTW....don't laugh at me too badly....stumbled into that before anyone had a chance to reply.

Sue