outer join

From: paul (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 09:20:05 -0700

Hi,
  In my Access 2k application, one of my query need a
outer join. How to create this? I have two tables, one is
Training table with employee no, and another table is
Employee table, with employee no and employee Last Name,
First Name.... In the Training table, some of the employee
may be retired, so in the Employee table, their name won't
exist. How can I create a query with all the Training
records (even the guy retired).
  I selected the Join Properties 3, which include all
records from Training table, but still missing those
retired.
  Thanks for your kindly help.

Relevant Pages

  • RE: How to code/perform a search
    ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... use a text box to capture search criteria from the user. ... The After Update event is to ...
    (microsoft.public.access.formscoding)
  • RE: How to code/perform a search
    ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... Dave Hargis, Microsoft Access MVP ... use a text box to capture search criteria from the user. ...
    (microsoft.public.access.formscoding)
  • RE: How to code/perform a search
    ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... Initially, the form was unbound, but then I could not enter the ... use a text box to capture search criteria from the user. ...
    (microsoft.public.access.formscoding)
  • RE: How to code/perform a search
    ... When I read your response, about 50% of it makes sense to me. ... use a text box to capture search criteria from the user. ... record from the query. ... The form has objects for each column in the employee table. ...
    (microsoft.public.access.formscoding)
  • Re: The query is too complex or cant open anymore databases
    ... record for each employee + each date of the current pay period, ... > Perhaps I can do a union query to arrive at a normal table structure? ... >>>I never thought that there was a limitation to the fields or calculations ... when overtime start. ...
    (microsoft.public.access.queries)