Simple cashbook Totals: When No Recs!

[XaloRichie]

I have a cashbook form which has two sub forms.
One based on a query of the cashbook table, for the amounts IN and another Based on a Query of the cashbook table for the amounts OUT.

When there is a day with no records on one or both sides I cannot get the "Total" Textbox to return Zero. Just #Error or #Name

I have read threads about IIF(Is Null( and NZ() But none of them seem to work.

When I have had the total zero, it remains so even if there is data in the subform.

Does anyone have or know of an example to make this work?

 

[GumbyD]

Can you post the database or at least some screen shots to look at? Being able to see the form design and code would make this easier to solve!

Thanks!

GumbyD

 

[Rich]

=Iif(IsNumeric(Forms! etc. etc, Forms! etc. etc, 0))

 

[XaloRichie]

Thanks will post some in the morning.

It's time to give it up for today

Will post something tomorrow. Cheers

 

[XaloRichie]

The Field has Sum() in text box

It doesn't work to the
field =Sum([Amount])
At least I cant make it.