Report Field Sum

[BobJ]

ok,

So on my orders form i have loads of fields which all addup like so:

Subtotal:

=Nz([txtCC])+Nz([Subtotal])+Nz([Subtotal2])+Nz([subtotal3])+Nz([Freight])+Nz([delivery cost])+Nz([consignmentcost])

VAT:

=Nz([Total])*0.175

Total:

=Nz([Total])+Nz([VAT])

now the Nz() bit i was told would fix any "blanks" for when a ceratin product type isnt required.. now this all works perfectly on the form.. however when i try to do the exact same thing on the report i just get #ERROR in all the fields where a certain product type wasnt selected.

i dont understand why its not working... have i left something out?

 

[BobJ]

k fixed it myself...

 

[boblarson]

k fixed it myself...

Please make sure to post back with your solution so it can help others who may come along with the same problem.

 

[BobJ]

well i kinda cheated, people wouldnt want to "fix" it the way i did. No choice as i have a deadline to meet.

 

[boblarson]

Ah, come on. Let us yell at you for doing a non-standard fix

No problem, I've done the same thing at times.

 

[BobJ]

lol ok then, be prepared to be disgusted!

I entered a new record in my tables called BLANK that has a price value of £0.00 hehe so each time a product isnt needed from one of the 3 subforms all my manager will have to do is select the BLANK "Product" in that subform ;D

 

[BobJ]

brings up all sorts of unwanted things.. ie a BLANK product on our invoices but ah well.. its a temporary fix just so i can show my boss what ive done hehe