beginning query question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Grip
    #1

    beginning query question

    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
    Tags: None
    • Tom van Stiphout
      #2
      Re: beginning query question

      On Sat, 21 Jun 2008 15:09:57 -0700 (PDT), Grip <grip@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

        Comment

        • Grip
          #3
          Re: beginning query question

          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

            Comment

            Previous template Next
            Working...