I would like to say first off that I have found many solutions to this, but they do not produce the outcome I need, so any help would be greatly appreciated.
Here is the scenario.
I get lead lists with phone numbers on them in field7. When I format the leads to address labels for the call center, I need to place those numbers into another "wash" table so that when the next set of leads come in, I wash the old numbers out to prevent recalling. So what I have been doing is creating a union query with each table (field7) and washing the new import to that query.
When I try to create a table from that query, it deletes all the SQL code and leaves me with "SELECT INTO wash1;"
then when I put my code into the SQL design:
"SELECT [field7]
FROM GR07019
UNION SELECT [field7]
FROM GR080109
UNION SELECT [field7]
FROM GR090109
UNION SELECT [Field7]
INTO Wash;
(The "GR070109" is the table I created from the lead import)
and run it, I get an error "Syntax error in FROM clause."
What I am really trying to accomplish here is to get a table with all the phone numbers in Field1 so that I can use it as the wash with out having to keep all the tables (old lead files) as a reference.
I am using Access 2007 and have a Vista machine.
Any help would be very appreciated!
Regards,
DK