Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • Last Modified:

Query - easy question

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
terpsichore
Asked:
terpsichore
1 Solution
 
bonjour-autCommented:
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
 
terpsichoreAuthor Commented:
thank you - this works just fine.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now