I have a large table (80 fields) with multiple address fields in it (Address1,City1, State1, Zip1, Address2 etc). Based upon another field having a specific character in it, I want to create another table with the address fields associated with that character. How can this be done? Do I use an Update Query? I would appreciate some examples.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need to extract data from one table into another
- Thread starter Lesl
- Start date
The use of a Make-Table query will serve your purposes. The following example can be used to fashion a query for your table and fields:
SELECT A.Address1, A.City1, A.State1, A.Zip1 INTO tblNew_AddrInfo
FROM tblYourTableName as A
WHERE (((A.Chr_FieldName)="A"
);
Now update the table with your table names, the appropriate field names, and lastly the correct character to select on and this will work for you.
Post back with any questions.
Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???
SELECT A.Address1, A.City1, A.State1, A.Zip1 INTO tblNew_AddrInfo
FROM tblYourTableName as A
WHERE (((A.Chr_FieldName)="A"
);Now update the table with your table names, the appropriate field names, and lastly the correct character to select on and this will work for you.
Post back with any questions.
Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???
- Status
Similar threads
- Question
- Locked
- Question