usage of subquery

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
i have qurery build from matched people now i need to make an average
of people without match but the problem is that this query is only for
match people is there a way to pull data as a subquery from the big
database for average of non matched as well?
 
Not as a subquery, but if you use an OuterJoin (All people and those in the
second table with a match) Then use "Is Null" as the criteria on the joined
field of the second table, you'll get your unmatched.

BTW, there is a wizard that may do it for you if your query is simple. Just
start a new query and pick the "Unmatched" wizard from the list.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subqueries 2
Subquery Help 4
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Subquery in an aggregate query. 3
Facial Recognition Software Recommendations 2
Subquery Correllated In Select Clause - Is this possible? 3
Microsoft has encountered an Error - 2
getting duped records from a table 1

Back
Top