Is it possible? Union Queries, Criteria based on a table values named as tblcriteria

[Mohsin Malik]

Hi All, i am stuck in the situation that, i have multiple tables and i have join these tables by using union queries, now i have created a new table tblcriteria which i want to use for applying criteria to these queries? Please guide me is it possible to apply criteria from table fields (the tblcriteria does not have any relationship with the data tables? Waiting for your kind response and direction. thanks

 

[plog]

Yes, but its probably not the most efficient way to do things. It involves VBA and excuting record sets.

What does your actual data look like and what does tblcriteria look like?( Field names, and sample data from both please.