Query expression return “Error” if a field meet a criteria - Microsoft Community

hi community, write in query 2 expressions following logic:

1st epxression 

       los: return word “error” if [los] contains numbers, otherwise return “ok”. 

2nd expression

       pid: return word “error” if [pid] contains text, otherwie return “ok”

thank help.

if want test if field contains number, use isnumeric:

iif(isnumeric(los), "numeric", "not numeric")

Office / Access / Windows other / Office 2013