Showing blank for "0" text value (1 Viewer)

[Elmobram22]

Hey,

I have a report that is based on a query I have made. It currently shows the values as kept in the table. It is for a MAR sheet. Here is how it looks...

Breakfast 0
Lunch 0
Teatime 2
Bedtime 1

I want it to show blank for each 0 that is shown. I have tried an Iif statement to do this but it doesnt seem to work. Any ideas would be greatly appreciated.

Cheers,

Paul

 

[kyo]

hi,
i think iif will work.
did you try like this?

IIf([field name],0,"")

 

[pr2-eugin]

Something along the lines of

IIF([theFieldName] = 0, "", [theFieldName])

 

[Galaxiom]

Another way to do it is with the Format property of the control where it is displayed in the report.

Enter this:

#;#;""

 

[Elmobram22]

Another way to do it is with the Format property of the control where it is displayed in the report.

Enter this:

#;#;""

Hi,

I tried that but it only works if its a number value apparantly. The Iif statement fails in the query...

Data type mismatch in criteria expression

Cheers,

Paul

 

[pr2-eugin]

Is your fieldName Text type? That's weird. Should they not be Number type as they are actually numbers?

 

[Elmobram22]

Yeah I had to make it text as I need to put in 1/2 values too

 

[Elmobram22]

Here is the database. The reports are there to see what I mean

 

[kyo]

hi,
please find attached

 

[Elmobram22]

Ahhhh now I get it. Thanks