Nz function in report...

  • Thread starter Thread starter James Newman
  • Start date Start date
J

James Newman

Hey all,

I have a report based on a crosstab query. I would like to convert
null values to zero or one so that some calculations work properly. I
have seen numerous questions and answers related to this question but
when I try to implement the solution it does not work,

I have a field in the report called demo.
The control source for the field is demo.

When I change the control source to:

Nz([Demo],1)

With this I get a circular reference error.

I know I am missing something simple!

Please help :)


Thanks,

James
 
Back
Top