Simplified question for matching terms

nancybrown

Well-known Member
Joined
Apr 7, 2005
Messages
868
I posted a question earlier and haven't received any solution. I apologize for making it sound more complicated than it probably really is. I'll try to explain my need:

I have 2 tables that I will include in a query: 2008 vendor terms; 2009 vendor terms. Unique identifier is the vendor ID #. The 2009 vendor terms has a column called "Updated Terms." Is there a formula that I can add in the Updated Terms column of the query that will return results of "Updated" if there is a difference in 2008 terms vs 2009 terms?

Any suggestions would be very much appreciated.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Code:
UPDATE 
[2009 vendor terms] 
INNER JOIN 
[2008 vendor terms] 
ON 
[2009 vendor terms].vendor_id = [2008 vendor terms].vendor_id 
SET [2009 vendor terms].[Updated Terms] = "Updated"

where 
(
    (
        [2009 vendor terms].term1 <>  [2008 vendor terms].term1 
        or
        [2009 vendor terms].term2 <>  [2008 vendor terms].term2 
    )
)
 
Upvote 0
in your Access database (your mdb file)
click on Queries
Create Query in Design View
hit Close
then View
SQL View
then paste the code in the window
then view
design view

but you will have to change some stuff
where I have
[2009 vendor terms].term1 <> [2008 vendor terms].term1
you will have to change both
term1
to your column name, and so on for term2 and every other term that needs to be checked for change
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,150
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top