I have an Access DB that I am trying to automate as much as possible. Currently there are several queries that have the month hardcoded into the query and every month I have to change them all manually. I added a dropdown to the form that fires the report, but have not been able to figure out how to attach the value selected to the queries. Can someone help me get through this process, as it would save me 30-40 minutes of work each time I run the report? I have tried this on a couple of other occasions and I have never conquered this task that everyone says is so easy. I must be doing something wrong or I am just an idiot.
coachdan32
coachdan32