• durai nagarajan (5/12/2011)


    looks same like iif

    can 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.