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.
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.