Query Criteria from another Query

[burrelly]

I have a list of employee's and they can have a number of different states, Employed - Perm, Employed - Temp etc etc

The table that stored the differnt employment states has a couple of columns one with the state and another with a yes / no to determin if the state is active.

SO what I am doing it running a query to show all the states with yes against them. The results of this I want to use as the criteria for another query.

Is that possible?

 

[Rabbie]

Yes. You can use a Select query any place you can use a table.

 

[burrelly]

What would I enter in the query criteria box?

 

[Rabbie]

What would I enter in the query criteria box?

Just put true in the selection box for the state.

 

[burrelly]

I am sorry but I do not understand

 

[Rabbie]

What don't you understand. It doesn't get simpler than setting the criteria for the employment active column to True or Yes. How hard can it be. Try thinking a little.

 

[burrelly]

I am thinking but I cant see how to impliment what you are saying.

I have attached a small sample to try and demonstrate what I want to achieve.

 

[burrelly]

No one? I really need some help