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

beginning query question

P: n/a
Just started teaching myself Access and I've got a newbie question...

I have two tables tblPpl and tblOrgs linked by a many-to-one
relationship. I'm trying to produce a report that will show a list of
people's names and their organizations. I've built a query to base
the report on with three columns, LastName from tblPpl, FirstName from
tblPpl and OrgName from tblOrgs.

The problem I'm having is the query does not 'find' people who are not
associated with an Org. This seems to be because the tbOrg is on the
query. If I delete the table from the query, all Ppl show up, but
then I can't use OrgName on the report.

What am I doing wrong?

I'm using Access 2002 on WIndows XP.

Thanks,
G
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sat, 21 Jun 2008 15:09:57 -0700 (PDT), Grip <gr**@cybermesa.com>
wrote:

Open the query in design view. Right-click the line between the two
tables. Choose "select all from tblPpl...".
It's called an "outer join" query.
-Tom.

>Just started teaching myself Access and I've got a newbie question...

I have two tables tblPpl and tblOrgs linked by a many-to-one
relationship. I'm trying to produce a report that will show a list of
people's names and their organizations. I've built a query to base
the report on with three columns, LastName from tblPpl, FirstName from
tblPpl and OrgName from tblOrgs.

The problem I'm having is the query does not 'find' people who are not
associated with an Org. This seems to be because the tbOrg is on the
query. If I delete the table from the query, all Ppl show up, but
then I can't use OrgName on the report.

What am I doing wrong?

I'm using Access 2002 on WIndows XP.

Thanks,
G
Jun 27 '08 #2

P: n/a
On Jun 21, 8:02 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Sat, 21 Jun 2008 15:09:57 -0700 (PDT), Grip <g...@cybermesa.com>
wrote:

Open the query in design view. Right-click the line between the two
tables. Choose "select all from tblPpl...".
It's called an "outer join" query.

-Tom.

Thanks, that was easy enough.
G
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.