If the location will always be formatted with "-" between the sections, try something like this:
NumberVar at = inStr({MyTable.Location}, '-');
if at > 0 then
if mid({MyTable.Location}, at + 1, 2) = '01' then
chr(226)
else chr(225)
When you put this formula on your report, change the font to
WingDings and you'll get the appropriate up or down arrow.
-Dell
IP Logged
