Calculating Totals on a Sub forms

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
 
B

Brian

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating two different totals from a sub form 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Instant Totals on Continuous Forms 0
How to make a sum of a sub-form on the main form 2
Sub totals on sub forms 2
Sub-form totals 6
Totals Row Not Summing 3
Calculating Totals of data in Access 2007 0

Top