I am wondering if I can create a macro to run an access query using SQL code for the query.
Basically what i want is to hit a button and the query will run in the database using the exact sequel i place in the vba macro.
The reason for this is I want the criteria of the query to change depending on the sheet.
Basically what i want is to hit a button and the query will run in the database using the exact sequel i place in the vba macro.
The reason for this is I want the criteria of the query to change depending on the sheet.
