ERROR REPORT

[Guest]

I have a column that has id that are alpha numeric and I need all those that
are not upper case or particular id into one table and all the rest in a
different table. Thanks for the help.

 

[[MVP] S.Clark]

Use a make table query to write the 'not upper case or particular id' to
another table. Delete them from the initial table when finished.

asc("a") = 97
asc("z") = 122
Chr$(97) = "a"
Chr$(122) = "z"

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[John Spencer]

If you want to find those records where the field is not all upper case you
can use
StrComp(Ucase([YourField]),[YourField],1) <> 0

As far as not a particular Id, just add an Or

WHERE ID <> "123" OR StrComp(Ucase([ID]),[ID],1) <> 0