Recent content by Olops

Sabi ko na nga ba pinoy.. sir pano ba kita ma private message? Trial and error plang kc ako.. bka may follow-up question pa ko... maraming salamat po..

Thank you very much arnelgp!!

Input data [Name] [Weight] aaa 100 aaa 103 aaa 103 bbb 60 ccc 300 ddd 500 eee 210 fff 4 fff 5 ggg 10 hhh 205 Desired output Nearest Weight fff - 4 and ggg - 10...

follow up question.. in my table there is duplicate data under the field [name], but i don't want to match them even they have the same or nearest weight value. What should i add to arnelgp's code?

Wow works great! Thanks arnelgp and thanks to all who responded.. well appreciated.

Hi, the table2 in attached picture are the one to be the output after i click the command button.

Im new in ms access/vba, how can i find the nearest value in the same field and save it in other field.. i have 2 fields, name and weight.. i want to match them by their weight value. Thanks in advance for your help.

Newbie here 👍