Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    3

    Unanswered: Access Query Help

    I have four tables that are linked by medication name. One table is the medication inventory and another table is medications that were loaded into a machine.

    I want to create a query that lists all of the medications that were loaded into the machine that are not in the current inventory.

    I want it to take all of the medications in the loads table, compare the meds to the inventory table, and only show the meds from the load table that do not show up on the inventory table.

    How would I do this?

    Thanks,
    Jason

  2. #2
    Join Date
    Sep 2003
    Posts
    228
    Under queries, select 'New'.
    Select 'Find Unmatched Query wizard'

    This wizard will walk you through the steps to find records from one table that are not in another.

Posting Permissions

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