#### nancybrown

##### Well-known Member

- Joined
- Apr 7, 2005

- Messages
- 868

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.