Need report help

[MIke_Csom_(Guest)]

I am trying to identify the correct date in a rate table using a scan lookup from an invoice table. For example:____Invoice date = 12/01/2003____Rate records____Record 1 = effective date 01/01/2002__ rate $50____Record 2 = effective date 01/01/2003__ rate $55____Record 3 = effective date 01/01/2004__ rate $60____I would like to create a field (if possible) that would return a rate of $55.____Any help is greatly appreciated,____Mike__

[kfleming]

You could get there using an approximate lookup relation that would include the date field. Approximate lookup finds the exact or next highest value in the related table index key.______Kathleen__R&R Support