>>I am trying to produce a report based which has a side-by-side comparison of fields from two different rows of the same table. In other words, I'm showing a Current and Past value next to each other.
>>
>>The question is, how do I get these values on the same page/detail row of a report?
>

Current value would be your first field. Next to it put PastVal() as the second field where:
**************
FUNCTION PastVal
*************
lnrec = RECNO()
SKIP (n) && or locate your Past val record
lcReturn = alias.field
GO (lnrec)
RETURN (lcReturn)
*

HTH
Sorin