nancybrown
Well-known Member
- Joined
- Apr 7, 2005
- Messages
- 868
In my query, I am using a table called 2008 Vendors, and 2009 Vendors; each has a payment term field.
I've added an extra column called "Updated Terms." Can someone tell me how to write a query that would the 2008 against the 2009 fields and to return one of the 3 results (I'd like to avoid SQL if possible):
If 2008 payment terms = 2009 payment terms "No Change"
If 2008 payment terms < 2009 payment terms "Updated"
If 2008 payment terms > 2009 payment terms "blank"
Thank you in advance.
I've added an extra column called "Updated Terms." Can someone tell me how to write a query that would the 2008 against the 2009 fields and to return one of the 3 results (I'd like to avoid SQL if possible):
If 2008 payment terms = 2009 payment terms "No Change"
If 2008 payment terms < 2009 payment terms "Updated"
If 2008 payment terms > 2009 payment terms "blank"
Thank you in advance.