Closest Match

W

WildThing

Hi, Like in Excel using a vlookup with true instead of false, the lookup will
look for the next largest value closest to that being looked for.

I need to recreate this function in Access by comparing a table with two
columns one text the other a date. I then want to look up this date on
another table and find the closest matching but smaller than value.

Thanks In Advance.
 
M

Michel Walsh

Hi,



DMin( "MyField", "MyTable", "MyField >=" & givenNumericalValue )




Hoping it may help,
Vanderghast, Access MVP
 
Top