AlphaNumeric Values

  • Thread starter Thread starter KW1978
  • Start date Start date
K

KW1978

I have a table that contains customer data. I want to flag any record that
contains no numerical values in the address field. Does anyone know of an
easy way to accomplish this?
 
I have a table that contains customer data. I want to flag any record that
contains no numerical values in the address field. Does anyone know of an
easy way to accomplish this?
Click to expand...

Use a criterion on the address field of

NOT LIKE "*[0123456789]*"
 
So you'd want to see an address like the following?:

PO Box A

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Ideally I would, but someone will be going over the rejected records manually
so it could be corrected at that point.
 
Back
Top