durai nagarajan (5/12/2011)
looks same like iifcan i know why you want to avoid iif
thanks
I have about a dozen columns in a table where the field values are either 1 or 0. For satisfactory display, it would be best to format the zeros to dashes. If a simple format code exists, then it saves the effort of having to write conditional expressions for each field.