By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,902 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Aug 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Aug 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.