SQL for multiple tables

L

lbsstacey

I have designed a database where I have many queries that look the same but
they each refer to a different table that contains specific client
information. I run my queries from a process form that contains an
abbreviated name that refers to each client. I am wondering how I can change
my query to instead of referring to the table "Terms_BE" I can refer to a
variable "Terms _" & [Forms]![MainForm]![AbbrName]

INSERT INTO Terms_BE ( SubSSn, MBRSSn, Rel, [Employee_First Name],
[Employee_Middle Initial], [Employee_Last Name], EffDate, TermDate, Field21,
Expr1 )
 
D

dymondjack

I've got this strange sense of deja vu... like I've seen this before
somewhere. Maybe I had a dream about it last night.

--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL to use for multiple queries 3
SQL with multiple similar queries 1
SQL variables 3
SQL question 3
SQL query with variable 3
Query Using Multiple Tables Based On A Parameter 3
SETVALUE in in Macro for subform control fails 2
append simultaneously to multiple tables from form 3

Top