Compare field in first record to same field in next record
I want to:
How can this be done?
This can be done by conditional formatting, using the GetNthRecord() function.
However, keep in mind that the term "next record" is very flexible in a database - it depends on the current found set and sort order.
Usually, it's best to avoid cross-dependencies among sibling records, and use a relationship in cases where it cannot be avoided.