Qry parameter

B

Bill H.

How can I make this work in a query:

PARAMETERS [tblname] TEXT;
INSERT into [tblname] . . .

I know I could build SQL in the VBA and go from there, but this seems more
elegant.

Thx.
 
K

Ken Snell \(MVP\)

You cannot do this in a stored query using a parameter. You'll need to use
VBA code to generate an SQL statement string on the fly.
 
Top