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 totals from a sub form to a main form 1
Help with totals on forms! 1
Sum of child form values shown in parent form and updated in database 3
Sub Form and Form Total 1
Help with a small problem. 2
Running Totals on Mainform 5
Subform Totals on Main form by Criteria 2
Sum Line Totals 10

Top