Previous function

[billj_(Guest)]

I am trying to select information in previous records, Previous function only works if the specified field is in the previous record. What if it is not in the previous record? ____IIF(id#=PREVIOUS(id#),PREVIOUS(ref#),"")..This only works if my id# is in the previous record. I need the following example.____ex: If my id# has been repeated several times and is not in the previous record I need to retrieve the ref#. Example below.____ex: ref# id#__ a01 1001__ a02 2002__ a03 1001 = a01__ a04 3200__ a05 3232__ a06 1001 = a03__ __Thanks for any help.

[kfleming]

If you wanted to test for a small discrete set of id^s you could use a set of calculation but if you wanted to test for any number of ids and those ids are not know in advance, the only way to get there would be to do two reports, the first a DBF export of ID^s and references and the second a relation to that exported table.____Kathleen__R&R Support____

[Alan_Klein]

What if you sort by ID Number and then run the Previous function?