Search results

I know there is a way to do this, but cannot find it on the web. I want to take eight different functions, all contained in one vba module, and run all of them with the click of a button I created on a form. How do I do this? Thanks!

Good questions, I'll try to clarify: 1. My raw data has state-level information. I created a reference table with state/region that I link to so I can sum my data by region (you won't see this table in my SQL code because my output query is querying other queries that have already summed the...

I have been using separate queries to output data to Excel (see code below for example), and this works fine. However, there is a need to slice the data by filters, which would mean writing hundreds of individual queries. I am hoping there is a way to write one parameter query and use VBA to...

I don't need 10 queries, but I do need 10 different, separate results,(one for each region), be it a table or something else as the end result

I am attempting to reference a table and create 10 different queries based on the parameter- Region #(1-10). This is my attempt at getting my first query filtered by Region I. I am trying to write this in VBA, and am getting an error: Compile Error: Syntax error. Here is what I have so far...