How to find a close match?

[DORI]

I have a table in Access with 250 rows and 3 columns.
The operators input a number let call it A.
I need a macro in VBA to search A to see if there is a match or closest
number to A on column 3 (let call it B) and then return the data on the same
row as B on calumn 1.
Any help is much appreciated.
DORI

 

[Steve Schapel]

DORI,

In Access, there is no such thing as "a macro in VBA". There are
macros, and there are VBA procedures, and they are quite different.

In any case, your question is not really for either. This is a job for
a Query. It would really help if you could give some examples of your
data and what you want to happen. And where do the "operators input a
number"? I assume in an unbound textbox on a form? Thanks.