test for no records found

[kronar]

I have a form that displays JobTime records in a subform. In the subform I total HbE from the query.
How can I use '=iif(iserror(sum(HbE), 0, sum(HbE))' as the Control Source of the field in the form footer?

 

[Remou]

If the subform allows additions, Nz will work, if not, the usual place to put the statement you show is on the parent form, with a proper reference to the subform.

http://lessthandot.com

 

[kronar]

the Form JobForm contains a subform JobTimesubform which is based on a query. In the footer of JobTimeSubform is a field 'TotalHrs' which has source =Sum(HbE)which is field in query.
On the JobForm I have afield whose source is [Form].[JobTimeSubfield]![TotalHrs]
If no records are found - I get #Error in the field.
How can I test for no data and load 0 instead?

 

[Remou]

Change the source from:

[Form].[JobTimeSubfield]![TotalHrs]

To

[tt]IIf(IsError([Form].[JobTimeSubfield]![TotalHrs]),0,[Form].[JobTimeSubfield]![TotalHrs])[/tt]

And see if that suits.

http://lessthandot.com

 

[kronar]

Thanks that worked, guess I needed the = in front of it.