Solved

Query - easy question

Posted on 2015-01-15
2
105 Views
Last Modified: 2015-01-15
Dear experts -
I have a subform driven off a temp table (Table 1). It has a control called 'action_ID'.

Now, I want to create a recordset that will select records from a different table (Table 2), where multiple conditions are met, including limiting the 'action_ID' field in Table 2 to those in the temp table (Table 1).

What is the easiest way to do this?

I was thinking of creating a DAO.Recordset, then doing a select statement on Table 2, and either doing a join or a subquery with Table 1.

Your thoughts are appreciated.
0
Comment
Question by:terpsichore
2 Comments
 
LVL 18

Accepted Solution

by:
bonjour-aut earned 500 total points
ID: 40551094
If table 1 is a real access table, the a query with inner join will do:

SELECT tbl2.*
FROM tbl2 INNER JOIN tbl1 ON tbl2.action_ID = tbl1.action_ID  where ((.............other restrictions.....................));
0
 

Author Closing Comment

by:terpsichore
ID: 40551124
thank you - this works just fine.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now