beginning query question

[Grip]

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

[Tom van Stiphout]

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

[Grip]

On Jun 21, 8:02 pm, Tom van Stiphout <[e-mail]:

On Sat, 21 Jun 2008 15:09:57 -0700 (PDT), Grip <[e-mail]>
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