nancybrown
Well-known Member
- Joined
- Apr 7, 2005
- Messages
- 868
I have a table in access that has vendor # and old vendor terms fields; this table is called 2008 Vendor Terms.
On a weekly basis, I will be linking an excel file to the access database that will be called 2009 Vendor Terms and also has vendor # and new vendor terms fields.
Does anyone know a query (for a button) I could use that will run and compare the 2008 vendor terms table against the linked 2009 vendor terms file? The results should return to another table within access called Updated Vendor Terms that will also have the vendor # and vendor terms.
Many thanks in advance.
On a weekly basis, I will be linking an excel file to the access database that will be called 2009 Vendor Terms and also has vendor # and new vendor terms fields.
Does anyone know a query (for a button) I could use that will run and compare the 2008 vendor terms table against the linked 2009 vendor terms file? The results should return to another table within access called Updated Vendor Terms that will also have the vendor # and vendor terms.
Many thanks in advance.