Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Thanked 0 Times in 0 Posts

    Cross Checking Access Tables (Access 2003)

    I have three tables, table A, table B, and table C. The conact id's from table A are used to identify the people in table B and table C. How do I get access to give me a list of everyone who is in table B, but not table C?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Cross Checking Access Tables (Access 2003)

    Welcome to Woody's Lounge!

    You can use the Find Unmatched Query Wizard for this:
    - Activate the Queries section of the database window.
    - Click the New button in the toolbar of the database window.
    - Select Find Unmatched Query Wizard and click OK.
    - In the first step of the wizard, select Table B, then click Next.
    - In the second step, select Table B, then click Next.
    - In the third step, specify the Contact ID field as field to join on (Access has probably already done so), then click Next.
    - In the fourth step, specify which other fields from Table B you want to display, then click Next.
    - In the last step, specify a name for the query (or accept the one proposed by Access), then click Finish.

    If you want to display info from Table A for the contacts, create a new query based on Table A and the query you just created.
    Join them on the Contact ID field.
    Add the fields from Table A you want to display.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts