Well the subreport I think the field (and it is a
calculated field)is null.
(the subreport will list all items that match the linking
fields, so I assume if there are no fields that match
then it is null?? To be more clear a customer is on the
main report and I have five subreports. One subreport
list part and or parts on order for the customer, one
subreport list service and or services performed for that
customer, one subreport list payment and or payments made
and so on. So any of the subreports can have no list,
can have one detail line or mutiple detail lines. SO I
really do not know if there is no list in that subreport
if the field is null or just not there.)
I have come to the NZ function, but can't figure out how
to use it. I still get the #error in the calculated
field on the main report. Do I use the NZ function in
the subreport on the field in the report footer or in the
field on the main report?
I also came across [HasData], what is this and how is it
used.
Thanks so much for your time
-----Original Message-----
I don't understand... do you mean the field is not
there
or that there is no
/ Null value in the field... if it is a matter of
Nulls,
look at the NZ
(aka Null-to-Zero) function.
Larry Linson
Microsoft Access MVP
