Liveware Publishing Support Forum

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__

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