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
---
This email is free from viruses and malware because avast! Antivirus protection
is active.
http://www.avast.com
