Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comparing Tables (MS Access 2003)

    I have two tables with identical fields - one is a journal (Table 1) and one is a new list of items (Table 2). I want to generate a list of records that are in Table 2 but not in Table 1. I know that I can delete items in 2 that are in 1 and then list those items, but I would rather just receive a list.

    Shihlaud

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Comparing Tables (MS Access 2003)

    the easiest way to do this is to use the Find Unmatched Query Wizard:
    - Activate the Queries section of the database window.
    - Click 'New' in the toolbar at the top of the database window.
    - Select 'Find Unmatched Query Wizard' and click OK.
    - In the first step of the wizard, select Table 2, then click Next.
    - In the second step, select Table 1, then click Next.
    - In the third step, identify the field(s) on which you want to compare the tables. Click the <=> button for each pair of fields, then click Next.
    - In the fourth step, select one or more fields you want to show in the list. Click >> if you want all fields. Then click Next.
    - In the last step, provide a name for the query, then click Finish.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing Tables (MS Access 2003)

    Thanks that what I needed!
    Shihalud

Posting Permissions

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