Blank fields in reports

[solomon]

Need some help again. How do i make a field in a report show or display zero if there's no value for that field. Currently the field i have just show blank when there is no data and i'd rather this show zero.

I have checked the properties and i cannot find any function that has the name default, which i could have just set to zero.

Any ideas, please.

 

[reclusivemonkey]

You won't get a zero value for any dates which are not in your table. I suspect this is your problem. Simply adding the date and a zero value should then give you a zero balance for that day. Although I believe I have answered this already...

 

[solomon]

This field is not for a date but just numbers and what i am trying to do is that: i have created a report from a query and two fields in the query seem not to show zero as default when there's no data or number entered in them. they are rather blank and i don't want this to show blank but zero (0) when nothing is entered.

I thought in a report i might be able to set a default when the field is blank to show zero as a number. is this impossible?

thanks for your help and time.

 

[Rich]

Nz([YourField],0) or Iif IsNull([YourField],0,[YourField])

 

[solomon]

Thanks Rich. Appreciate the time. It worked fine, Magic! Thanks everyone who helped out......