Lookup

[jmq]

Suppose i have a value of 2,356 and i want to look to a table SSS_Contributions to get the appropriate contribution, how would i do that if:

tblSSS_Contribution:
[Basic] [Contribution]
1000 50
2000 100
3000 150


thanks

 

[bob fitz]

Perhaps something like DMax("Contribution","SSS_Contributions","Basic < 2356")

 

[jmq]

@bob fitz: Exactly!

Dlookup("[Contribution]", "SSS_Contributions", "[BasicPay]=" & DMax("[BasicPay]","SSS_Contributions","[Basic] <= 2356") )