Hi Doug, seems to be the only way J
thank´s for your help, Fritz Von: [email protected] [mailto:[email protected]] Im Auftrag von Doug Hamilton Gesendet: Mittwoch, 9. Juli 2014 04:50 An: RBASE-L Mailing List Betreff: [RBASE-L] - Re: Display Feedback on Data with the IFF function The IFF will work on values in the same row. You're info column depends on values in two different rows. So you are correct - you need the year column to put the rows in the proper order. I've done something like this by creating a temp table and adding the info column. Then cursor through with an order by (year in this case) and compare the previous to the current year. Once you've done that, you could then indicate +3, -1, +2...and then add colors - red if > 3, .... and then... Doug On 7/8/2014 1:05 PM, Dr. Fritz Luettgens wrote: Hi, year(col1) turnover(col2) info(col3) 2011 3 2012 6 + 2013 5 - 2014 7 + I want to add to the info column "+" or "-" with the UPDATE command using the IFF function (IFF('.v1<.v2','+','-')) but cannot get it working because I think I need the year as reference. Is there a different function I can use ? Thank´s fritz _____ <http://www.avast.com/> This email is free from viruses and malware because avast! Antivirus <http://www.avast.com/> protection is active.
