How can I create a parameter query in access where the parameter variable specifies the column name?
J js_280 Jun 17, 2005 #1 How can I create a parameter query in access where the parameter variable specifies the column name?
V Van T. Dinh Jun 17, 2005 #2 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.
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.
