Lookup (1 Viewer)

jmq

Registered User.
Local time
Today, 01:40
Joined
Oct 4, 2017
Messages
87
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

AWF VIP
Local time
Today, 08:40
Joined
May 23, 2011
Messages
4,717
Perhaps something like DMax("Contribution","SSS_Contributions","Basic < 2356")
 

jmq

Registered User.
Local time
Today, 01:40
Joined
Oct 4, 2017
Messages
87
@bob fitz: Exactly!

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

Users who are viewing this thread

Top Bottom