Running a Query with Different Values Problem

[pinkpanther6666]

i have written a query where i have put the [ ] in.
When i run a report based on the query runs it asks for me for a value and i input a value and the query runs correctly
Written a macro which saves this report to my hard drive
However
How can i automate the above but i need run the report multiple times with different values


Can anyone please point me in the right direction


Many Thanks


Steve
Using Access 2016

 

[FDibbins]

xenou

Thanks for the input and explanation - much appreciated