Parameter query for variable column name...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I create a parameter query in access where the parameter variable
specifies the column name?
 
AFAIK, you can't use Parameter for Column name.

You need to construct the SQL String by VBA code using the "Parameter" value
in the SQL construction so that your SQL at the end have the explicit name
for the Column.
 
You must log in or register to reply here.

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

Sources for query parameters 10
Parameter Query Won't Run 0
Parameter Query with DSum 1
Access Invalid bracketing of parameter name 1
Parameter Queries in Crosstab Query 2
Building Complex Criteria for Queries in Access 2007 1
Modify Parameter Query 1
Variable as query parameter 1

Back
Top