Blank vs. Zeros for null values. Need some help

[Mitsu]

I created some queries and all the numbers appear for the values that I want (e.g. 1-10), but when there is no value of 1 to 10, the null value is expressed as blank rather than zero. How do I make the zeros appear for the null value. Do I need to use a certain expression. Would I be able to insert the expression in the report for that corresponding query? I would appreciate some help. Thanks

 

[Dugantrain]

An Iif expression will do the trick:
The basic syntax of an Iif function is:

Iif(Expression,Arg1, Arg2)

where Expression is what is being tested (in this case, the field from your table), Arg1 is the return value if the Expression is True, Arg2 is the return value if it is false.
In your query design, define a new field by:

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

 

[Mitsu]

Thanks for your help.