I have the attached access database and have 2 tables.
tbl_import - is all new information directly from companies.
tbl2 - is the table i need to append the import to.
Is there a way to add criteria to my qry_app to make it so it checks for the vendor name and record type not equal to "Direct"? For example, i want all the items in tbl_import to go to table 2 since the record type is "Direct". If it were "AP", company 1 & 5 would not be appended.
I cannot add a column to my import.