Simple Query

[google3luo359]

Hi Folks, I'm a bit rusty on building my queries after being away from
this for a few years.
I know this one's simple but I could use a pointer or two.

Table1 has all the students as records (StudentNum, Names, etc.)
Table2 has student plans.
The two tables are linked via StudentNum.

I simply want a query that pulls up students who haven't yet filled out
their plans yet.
So, all the students from Table1 who don't appear in Table 2.

TIA Ric

 

['69 Camaro]

Hi, Ric.

I simply want a query that pulls up students who haven't yet filled out
their plans yet.
So, all the students from Table1 who don't appear in Table 2.

Access will build this query for you if you'd like to use the Find Unmatched
Query Wizard.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[google3luo359]

Hi, Ric.


Access will build this query for you if you'd like to use the Find Unmatched
Query Wizard.

Thanks Gunny that worked out very nicely. I never even knew there was
that wizard there at the bottom of the list!
The problem I had before when I was trying to create it myself was that
I didn't do a left join, just a straight join between the two tables. I
never would have thought of that.
Everything else was the same inside the query.

Ric

 

['69 Camaro]

Hi, Ric.

You're welcome!

The problem I had before when I was trying to create it myself was that
I didn't do a left join, just a straight join between the two tables. I
never would have thought of that.
Everything else was the same inside the query.

You know, you can go the whole nine yards, but with Access, it's those last
couple of inches that seem to be the hardest. "I'm _almost_ there!" Access
has a pretty steep learning curve, but you have access to some excellent
resources in the newsgroups for assistance. Just post a question when you
get to a hard part, and the experts will help you through.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.