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

criteria problem

P: n/a
hi all !

i have a query to bring out results in a table however the criteria of
names that it brings out is from another query.access wont let me do
this in the query builder.how can i do this or maybe im doing it the
wrong way ??
thanks
brino

Oct 9 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ray
Hi Brino,

You can do it in the query grid with a little mucking about.

I will assume vNameList as the name of the query with the list of names
that you want to use as criteria.

Open vNameList in Design view, switch to SQL view and copy the SQL
script.

Open your final query, and in the critieria enter
IN ()

and paste your SQL script in between the braces.
Ray

Oct 9 '06 #2

P: n/a
thanks heaps !!!!!!

brino

ra*@aic.net.au wrote:
Hi Brino,

You can do it in the query grid with a little mucking about.

I will assume vNameList as the name of the query with the list of names
that you want to use as criteria.

Open vNameList in Design view, switch to SQL view and copy the SQL
script.

Open your final query, and in the critieria enter
IN ()

and paste your SQL script in between the braces.
Ray
Oct 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.