Pull info from one table to make many

[Guest]

I have four tables. Call them Table1 ... Table4 All of the tables only have
one field, Field1.
I want a query that runs through Table4 and:

Puts all of the records that contain a 1 as the 19th character into Table1
and all of the records that have 2 as the 19th character into Table2 unless
the record contains the word WARNING then it goes into Table3.

 

[Tom Ellison]

Dear Julia:

In part:

SELECT *
FROM YourTable
WHERE Mid(SomeColumn19, 1) IN (1, 2)
AND SomeColumn LIKE ("*WARNING*")

I do not know the name of your table or columns. You'll need to fix that
up.

Tom Ellison