Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: Database - Database Comparison

    I have a database which I run once a month.
    It has a table called 'Alpha', I need to compare the data on the new Alpha to the old one, eg;

    Old Alpha

    1
    2
    3
    4
    5
    6
    7
    8
    9

    New Alpha

    2
    4
    6
    8
    13
    15
    16
    17

    I need to

    a] Generate a list of values which appear in the old Alpha table only.

    1
    3
    5
    7
    9

    b] Generate a list which appear in the new Alpha table only.

    13
    15
    16
    17

    Help!

  2. #2
    Join Date
    Nov 2003
    Posts
    4

    Re: Database - Database Comparison

    My Bad - I guess you just use 'Find unmatched query wizard' right?

  3. #3
    Join Date
    Nov 2003
    Location
    Plymouth, UK
    Posts
    59
    or start a query in design mode, link the field and click on the arrow of the link and select join type, this will give you what you need!!

Posting Permissions

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