>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only