Dynamic Criteria in Query from Table

[vineet78]

Hi

I have a simple query in Which Want to use Dynamic criteria from another Table.
I want to use criteria from the table one field at one time.

Thus for 10 criterias , query needs to be run 10 times using one criteria from table at one time.

Please suggest how this is achievable.

Regards
Vineet

 

[xenou]

This would be one way (using union):

select * from x where [first criteria] 
union all
select * from x where [second criteria]
union all
select * from x where [third criteria]

this would be another (using Or logic)

select * from table 
where
(
    (first criteria)
    or
    (second criteria)
    or
    (third criteria)
)

 

[xenou]

Note that if you literally want to run the query ten times (separately) than simply:

select * from x where [first criteria] 
select * from x where [second criteria]
select * from x where [third criteria]

You can run these using DoCmd in a vba subroutine or similarly using some setup with MSAccess macros in order to execute them in sequence "automatically" (or with some automation anyway).