If I have a table fields= Card,detail# and and duplicates are allowed how do I find the most current since Seek locates the first one? For example if I have the following:
x3399 8002
x3399 8003
x3399 8004
x3399 8005 <--- I want this one since it's most current
I tried to reverse "index on card# +str(VAL(detail)*-1) TO m-index"
but detail still ends up in ascending order.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."