I have several queries that have static criteria typed in. These are each specific to the user. The users are spread out and need to only see their data sets so I set the criteria then rename and send the DB.
My question is how could I point the various queries and various fields to a table with one record in it that is all the different filters?
Is that even the best way?
Example of what I have:
DB_Texas_Sales_Pete
Qry_1 – State field criteria “Texas”
Qry_2 – Region Field criteria “South”
DB_NY_Sales_Steve
Qry_1 – State field criteria “NY”
Qry_2 – Region Field criteria “NE”
Example of what I think I need
DB_Texas_Sales_Pete
Qry_1 – State field criteria “tbl_config.State.top_1” and it is set as “Texas”
My question is how could I point the various queries and various fields to a table with one record in it that is all the different filters?
Is that even the best way?
Example of what I have:
DB_Texas_Sales_Pete
Qry_1 – State field criteria “Texas”
Qry_2 – Region Field criteria “South”
DB_NY_Sales_Steve
Qry_1 – State field criteria “NY”
Qry_2 – Region Field criteria “NE”
Example of what I think I need
DB_Texas_Sales_Pete
Qry_1 – State field criteria “tbl_config.State.top_1” and it is set as “Texas”