Parameter Value prompts for Table Name
Posted on 2014-04-23
There may be an answer already for this question, if so, please direct me to that posting as I was having difficulty to know what key words to search for:
My question is, is it possible to create a query where the parameter calls for a specific table (not a field)? I know it can be used to call a specific date or text parameter from a table, but I was wanting to actually call a specific table to run the query.
Since I update "[Current Month/Year]" table to a table I've named "[New]" and "[Previous Month/Year]" table to a table I've named "[Old]", to ensure I've copied the correct information into each table, I compare the tables via a query (e.g., do the sums of the tables match?). Each month the "[Current Month/Year]" table or "[Previous Month/Year]" table names change.
When I run the comparison query, is there a way to call the "[Current Month/Year]" table or "[Previous Month/Year]" table instead of having to modify the comparison query each month? Or is this something that would need to be created in VBA? If so, so you have some tips in how to write it. I'm not proficient in VBA.