var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
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.