Subform totals problem

[Gaffer]

Hi

I have an annoying problem with a subform on Access XP. The subform is bound to a table and the field totals are totalled in the form footer. This works fine when the form view is set to Single form. However I need to view the data in rows. But if I set the form view to Continuous Forms, the subtotal formulae return errors.

I've tried using NZ, and NNZ, but with no joy. They still return errors.

Any suggestions gratefully received!

 

[Rich]

What's NNZ?
post the formula you're using

 

[Gaffer]

NNZ is a function I came across whilst looking for postings on similar problems to mine. It is:

Function nnz(TestValue As Variant) As Variant
'Not Numeric return zero
If Not (IsNumeric(TestValue)) Then
nnz = 0
Else
nnz = TestValue
End If
End Function

However it didn't sort out the problem.

I've just about managed to sort it out now. I set up a query and instead of binding the subform to the table bound it to the query. The subform totals now seem to work happily now. Simple solutions...!

Cheers!