G
Guest
This does what I want it to do, but it's so long, and I know there must be a
shorter/easier way of writing it.
Any help is very much appreciated!
DxCode: IIf([Dx1Code] Like "V72.3*","V72.3*",IIf([Dx2Code] Like
"V72.3*","V72.3*",IIf([Dx3Code] Like "V72.3*","V72.3*",IIf([Dx4Code] Like
"V72.3*","V72.3*",IIf([Dx1Code] Like "V25*","V25*",IIf([Dx2Code] Like
"V25*","V25*",IIf([Dx3Code] Like "V25*","V25*",IIf([Dx4Code] Like
"V25*","V25*"))))))))
shorter/easier way of writing it.
Any help is very much appreciated!
DxCode: IIf([Dx1Code] Like "V72.3*","V72.3*",IIf([Dx2Code] Like
"V72.3*","V72.3*",IIf([Dx3Code] Like "V72.3*","V72.3*",IIf([Dx4Code] Like
"V72.3*","V72.3*",IIf([Dx1Code] Like "V25*","V25*",IIf([Dx2Code] Like
"V25*","V25*",IIf([Dx3Code] Like "V25*","V25*",IIf([Dx4Code] Like
"V25*","V25*"))))))))