If then statement for a query

[4myfreedom]

It's been awhile so I really have forgotten the basics. My apologies. I want to "filter" a field in a query that a report uses. If the field contains a "0" (zero) I don't want that passed to the report for that field (i.e., a "") should it contain text, then I want it passed through. How do you do this. Thanks so much.

 

[Beetle]

In the field row of a column in your query, use something like;

FieldAlias: IIf([YourField] = 0, "", [YourField])

Replace FieldAlias with whatever name you want to appear as the field name in the query.