Qry parameter

  • Thread starter Thread starter Bill H.
  • Start date Start date
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.
 
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.
 
Back
Top