What is wrong with this statement.
TransTbl is the table on which the query will run.
Assoc and LastName are fields of the table. InAssoc is defined text variable which can change each time the query is executed Please help.
Code:
"SELECT * FROM [TransTbl] WHERE [TransTbl].[Assoc] = & 'InAssoc' & " & _
"ORDER BY [TransTbl].[LastName]"
TransTbl is the table on which the query will run.
Assoc and LastName are fields of the table. InAssoc is defined text variable which can change each time the query is executed Please help.