C
CW
On my Job Costing form I have two subforms, one for sales invoices and the
other for cost invoices. These are continuous forms and each has a Total
control in its footer that sums the amounts using =Sum([SalesValue]) and
=Sum([CostValue]).
If no invoices have been entered yet (on either side) I need the Total
control(s) to show 0.00, rather than a blank.
Question 1: I cannot get Nz to do this, could you please confirm how the
Total record source should be expressed?
Then on the main Job Costing form I have 3 controls for Sales, Costs,
Profit/Loss.
The Sales and Costs controls pull from the above-mentioned Totals on the
subforms and obviously the P/L control is calculated from those.
If either of the subform Totals is blank, the relevant main form control
will be blank, as will the Profit/Loss calculated control. I want those to be
0.00, not blanks.
Question 2: Will the correct use of Nz in the subform Totals cure this, or
will I need to add Nz to the main form controls too? And if so, how should I
modify the existing record source which is for example
=[frmCostssubform].[Form]![TotalCosts]
Many thanks
CW
other for cost invoices. These are continuous forms and each has a Total
control in its footer that sums the amounts using =Sum([SalesValue]) and
=Sum([CostValue]).
If no invoices have been entered yet (on either side) I need the Total
control(s) to show 0.00, rather than a blank.
Question 1: I cannot get Nz to do this, could you please confirm how the
Total record source should be expressed?
Then on the main Job Costing form I have 3 controls for Sales, Costs,
Profit/Loss.
The Sales and Costs controls pull from the above-mentioned Totals on the
subforms and obviously the P/L control is calculated from those.
If either of the subform Totals is blank, the relevant main form control
will be blank, as will the Profit/Loss calculated control. I want those to be
0.00, not blanks.
Question 2: Will the correct use of Nz in the subform Totals cure this, or
will I need to add Nz to the main form controls too? And if so, how should I
modify the existing record source which is for example
=[frmCostssubform].[Form]![TotalCosts]
Many thanks
CW