Choosing one of two fields in database based on data in one of them Follow
I have a situation to solve and it is like that:
I use connection to an excel database, Lets say for example database has 2 columns A and B.
Now in column A I have default data - product name. And in that record on column B i have a "yes" or "no" tag. So, in the field I have to print data from column A if the column B says "yes" and if column B says "no" I have to - instead of data from column A - print "Changed" - just this word.
Is there a way to do something like that? If so, how should I go about it?
Thanks for the response!