Making -1 display as X

[Guest]

I have a query that counts checkboxes and it shows the min (ie -1, or 0).
I need all the -1's to display as "X".
Is there anyway to do this?

Thanks

 

[Guest]

Use Iif statement.

 

[John Vinson]

I have a query that counts checkboxes and it shows the min (ie -1, or 0).
I need all the -1's to display as "X".
Is there anyway to do this?

Thanks

One sneaky way is to use the "four value format" property of a
textbox. You can set the Format of a textbox to a string of four
formats separated by semicolons; these provide different formats for
positive, negative, zero and NULL values respectively. Since a yes/no
field only has values 0 and -1 only two of these are relevant:

"";"X";"";""

will display X for -1, and nothing for any other value.

John W. Vinson[MVP]