VBA to change access database query

[kenadams378]

Morning,

I'm trying to write a piece of code to change the criteria of an access database query.

I already have a pivot table linked to the database, as part of the macro i need to be able to change the reporting month in the query criteria.

Is there a way to do this?

[cytop]

Yes - but as you haven't given any specific details it's not easy to give an exact answer.

In general, you can open a query definition and change the actual SQL statement, or convert the query to a parameter query and then provide the month when running the query. The latter is the easiest option (in my opinion)

[kenadams378]

So i could have the respective date within the workbook and ask the VBA to pick up that data and change the database query to match that date?