Calculating Totals on a Sub forms

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I have designed an invoice which includes a datasheet sub form with 2 colums
to sum with a GRAND SUM on the main form. To avoid displaying £0.00 in every
row I re-set the default value in the underlying table from 0 to blank
Now I notice that the TOTAL VALUE BOX on the main form will not display a
total if one of the column does not have an entry. I have to type a 0.00
value on at least one row to get it to function.
Anyone know of a fix or work-around?
Thanks
 
Sean
Good knowledge
Thanks a lot

Beetle said:
Use the Nz function

Nz([SomeField],0) + Nz([SomeOtherField],0)
--
_________

Sean Bailey


Brian said:
I have designed an invoice which includes a datasheet sub form with 2 colums
to sum with a GRAND SUM on the main form. To avoid displaying £0.00 in every
row I re-set the default value in the underlying table from 0 to blank
Now I notice that the TOTAL VALUE BOX on the main form will not display a
total if one of the column does not have an entry. I have to type a 0.00
value on at least one row to get it to function.
Anyone know of a fix or work-around?
Thanks
Click to expand...
Click to expand...
 
Back
Top