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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
this is killing me. INDEX/MATCH "closest to X" in a smart way? 6
Crate Table Query - Closest to the 15th day..... 0
How can i create a query on text input to return closest match? 1
Function to Return a Date Value Q 4
Need help modifying code 0
Like VLookUp True/Closest Match 1
Finding Closest Text Match 3

Top