DLookup for Multiple Criteria including a Between

[jmkingpin]

DLookup works great when i just use a between argument but as soon as I add the second criteria where the [Data Month] must match the [PayoutYear] I get blanks or errors based on the syntax. It this possible? If so, how?

DLookUp("[PayoutTier]","t_PayoutGrid",[Bump iGPQ] & " Between [iGPQLow] and [iGPQHigh]" & "' and [PayoutYear] = " & Left([Data Month],4)))

[Seth Schrock]

The syntax for your criteria would be

"[Bump iGPQ] Between " & [iGPQLow] & " And " & [iGPQHigh] & " And [PayoutYear] = " & Left([Data Month], 4)

This assumes that each field is a number field.

[jmkingpin]

I could swear I tried that on one of my 50 attempts, but clearly I did not because yours worked! Thank YOU!

[NeoPa]

Sometimes that's all it takes. Trying something again carefully that you thought had already failed the test.

I often find when I run through for someone what I've already tried, it just works.