Zero filling a report field

[garyd1234]

Hi,
I have a report running which uses a query as its source. One field in the detail sometimes will not have a value after a calculation is done in the SQL statement of the query. I want that field to show 0.00 if there is nothing (null) in it. It won't. How do I get it to show 0.00. I tried using Nz(fieldname, "0.00") in the SQL and it doesn't work. There is no default property for that field on the report. ???

Thanks

Gary

 

[Russell Hauf]

Can you give a little information about your query? You should be able to generate the 0 values in the query.

 

[mdmilner]

Thought about not posting this because I'm not 100% on this, but I think you're supposed to put the NZ function in the Report itself.

 

[Dugantrain]

Iif(([Your_Field] Is Null), 0, [Your_Field])

This needs to go in your underlying query. Take out your original field and put this in its place.