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

Many query criteria located in a linked table.

P: 1
The problem I am having is setting up some code to query a table(Tbl_Table1_ContainsLotsOfData)
using criteria in another table(Tbl_Table2_ContainsCriteria),
then appending the result to an existing table(Tbl_WantedResult).


Tbl_Table1_ContainsLotsOfData
SerialNumber PartName PartModel
0000000001 PartA ModelOFfPartA
0000000002 PartB ModelOFfPartB
0000000003 PartC ModelOFfPartC
0000000004 PartD ModelOFfPartD
0000000005 PartE ModelOFfPartE



Tbl_Table2_ContainsCriteria
SerialNumber
0000000002
0000000004



Tbl_WantedResult
0000000002 PartB ModelOFfPartB
0000000004 PartD ModelOFfPartD

I do need to use some sort of function on this one. The system I am working with does not allow unqualified searches so JOIN is out of the question.

The query works fine if I use
0000000002 Or 0000000004
as search criteria on Tbl_Table1_ContainsLotsOfData in an append query pointing to Tbl_WantedResult


But the search criteria I need to use is over 200 entries, is dynamic and is located in a linked table.

Any help you can give me with this would be greatly appreciated.
Jun 6 '07 #1
Share this Question
Share on Google+
1 Reply

Rabbit
Expert Mod 10K+
P: 12,441
The problem I am having is setting up some code to query a table(Tbl_Table1_ContainsLotsOfData)
using criteria in another table(Tbl_Table2_ContainsCriteria),
then appending the result to an existing table(Tbl_WantedResult).


Tbl_Table1_ContainsLotsOfData
SerialNumber PartName PartModel
0000000001 PartA ModelOFfPartA
0000000002 PartB ModelOFfPartB
0000000003 PartC ModelOFfPartC
0000000004 PartD ModelOFfPartD
0000000005 PartE ModelOFfPartE



Tbl_Table2_ContainsCriteria
SerialNumber
0000000002
0000000004



Tbl_WantedResult
0000000002 PartB ModelOFfPartB
0000000004 PartD ModelOFfPartD

I do need to use some sort of function on this one. The system I am working with does not allow unqualified searches so JOIN is out of the question.

The query works fine if I use
0000000002 Or 0000000004
as search criteria on Tbl_Table1_ContainsLotsOfData in an append query pointing to Tbl_WantedResult


But the search criteria I need to use is over 200 entries, is dynamic and is located in a linked table.

Any help you can give me with this would be greatly appreciated.
What do you mean that it doesn't allow unqualified searches? Why can't you just join?

If you can't join, try a subquery.
Jun 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.