How can I use a value from a table as a criteria in a Query

[Brian Blair]

I have a query that used to prompt you for a input. I want to use a
value from a table instead of the input. How do I do this.

[Terry Kreft]

You would use a sub-query.

So you create a query which returnsthevalue you want from the table, you
would then use this in your current query in place of the criteria.

Alternatively you can add the table to the query using a join which will
then act as filter on the query to only bring back lines which match.
--

Terry Kreft
"Brian Blair" <ag*****@shaw.cawrote in message
news:72********************************@4ax.com...

I have a query that used to prompt you for a input. I want to use a
value from a table instead of the input. How do I do this.