Dear Query Experts,
I want to highlight UPC's containing alpha characters in a UPC list. I can do this by the statement Non UPC: IIf(InStr(1,[IMMFNO],"A")>0,"Non UPC",""). This statement will bring up all UPC's that contain the letter A. How can I select UPC's that contain any letter "A thru Z" without writing 26 statements?
Did I say you guys are the best and I really appreciate your timely help?
Thanks & regards
Scott
I want to highlight UPC's containing alpha characters in a UPC list. I can do this by the statement Non UPC: IIf(InStr(1,[IMMFNO],"A")>0,"Non UPC",""). This statement will bring up all UPC's that contain the letter A. How can I select UPC's that contain any letter "A thru Z" without writing 26 statements?
Did I say you guys are the best and I really appreciate your timely help?
Thanks & regards
Scott