Table 1) Inventory (linked to xls File that changes Daily) (with Stock Numbers as Primary Key)
Table 2) Inventory that is Online (linked to a text file that changes Daily)
Tbale 3) Inventory psyically Not here (I manually enter Stock #'s here)
I need a Query, that Will Check Table 1 and tell me which records are not in Table 2, but Exclude the records that are listed in Table 3.
Basicly, Table 1 Comes from my system and shows everything I own in inventory, Table 2 shows everything I have online, and table 3 is where I keep a list of units that are not at the location. (could have been returned, broken, etc. They dont need to go-online.