Matching Terms

[nancybrown]

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.

 

[SydneyGeek]

If the Vendor # is the same in both systems, join the 2 tables on Vendor # and add the two different Vendor Terms fields. That will show all vendors who exist in both years. If (as is likely) there are vendors in only one of the two years and you want to show those, a different approach is required. Take a look at this tutorial.

Denis

 

[nancybrown]

Many thanks