In a report, how do I tell Access to place a zero in a field if the field is blank.

=iif(isnull([fieldname]),0,[fieldname])

I tried this, on a report that is not running off a query, and I still get 1.

look up nz fuction

in the format for the cell on the report enter :-

0.00;;;0

the first option is the format of the field displaying. The end option is what appears if the field is null in this case 0. It could be 0.00% or even a string like N/A.

hope this helps