S
sduraybito
I'd like to use a parameter value box to rewrite the table name for a
query:
Exsiting query:
SELECT [TABLE1].FirstName, [TABLE1].LastName, [TABLE1].Address1,
[TABLE1].Address2, [TABLE1].City, [TABLE1].State, [TABLE1].Zip,
FROM TABLE1
I'd like to change it to:
SELECT [TABLE2].FirstName, [TABLE2].LastName, [TABLE2].Address1,
[TABLE2].Address2, [TABLE2].City, [TABLE2].State, [TABLE2].Zip,
FROM TABLE2
without copy/pasting SQL into Notepad and replacing TABLE1 with
TABLE2.
Can I do this through Access?
TIA
Siegfried
query:
Exsiting query:
SELECT [TABLE1].FirstName, [TABLE1].LastName, [TABLE1].Address1,
[TABLE1].Address2, [TABLE1].City, [TABLE1].State, [TABLE1].Zip,
FROM TABLE1
I'd like to change it to:
SELECT [TABLE2].FirstName, [TABLE2].LastName, [TABLE2].Address1,
[TABLE2].Address2, [TABLE2].City, [TABLE2].State, [TABLE2].Zip,
FROM TABLE2
without copy/pasting SQL into Notepad and replacing TABLE1 with
TABLE2.
Can I do this through Access?
TIA
Siegfried