Results 1 to 2 of 2
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    St Louis, Missouri, USA
    Thanked 1 Time in 1 Post

    Query Differences (2000)

    My predecessor in this project made a mess that I have to clean up. When new items are added, they are only being added to one table and not all the tables. Yes, I know it is not good table design but until the client decides to re-do the DB I am stuck with it.

    I need help writing a query that looks for items in one table that are not in another. Then I will write an append to put this info in all the places it needs to go.

    <pre>SELECT qryUnique2005.SKU, qryUnique2005.BYear, [Admin Fee].SKU, [Admin Fee].BYear
    FROM qryUnique2005 INNER JOIN [Admin Fee] ON (qryUnique2005.SKU = [Admin Fee].SKU)
    AND (qryUnique2005.BYear = [Admin Fee].BYear);</pre>

    This is not working! I am getting a list of Unique SKUs for 2005. Now I need to know which are not in [Admin Fee].SKU

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

    Re: Query Differences (2000)

    The easiest way to do this is to use the Find Unmatched Query Wizard:
    - Activate the Queries "tab" of the database window.
    - Click the New button at the top of the database window.
    - Select Find Unmatched Query Wizard.
    - Follow the instructions.

Posting Permissions

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