Change output

[Guest_imported]

I have a value in my report that equals zero. How can I hide this value where it will not show anything for it:

Current output:

fieldname
-----------
0

I want this output:

fieldname
-----------




Can some advise what property or what I need to change to get this output in my Access Report??

 

[BusMgr]

Try an IIf

=IIf([Value]=0,"",[Value])

 

[Guest_imported]

If my fieldname is proj_id then I would put this in my criteria part column for proj_id in the Properties/report Record source?? I tried this and it gives me an error message.
I also tried puttin it in the control source of field but still not working.
Please advise>


IIf([proj_id]=0,"",[proj_id])