LIKE "5*" (1 Viewer)

[ctaylor]

I want to force a UNIT PRICE value 0 to appear for all ORDNUM_28 which begin with the digit 5.

My attempt to run the following within a query is not working and I'm hard pressed to figure out why. I have never used the LIKE method before......

Please help.

UnitPrice: IIf([SO Detail]![ORDNUM_28] Like "5*",0,[SO Detail]![PRICE_28])

 

[bob makepeace]

Hi,

You can only use the like operator on text
fields so you need to convert the ordnum_28
field to a string.ie.

UnitPrice: IIf(cstr([SO Detail]![ORDNUM_28]) Like "5*",0,[SO Detail]![PRICE_28])

bob