Vlookup type search and retrieve

[abinjoseph]

Good Day all,



I am fairly new to Access. Taken a few courses, but still practicing to get better. Not really too familiar with VBA but would like to learn. I am trying to search a table like vlookup in Excel. Basically I have a table that has a salary range in two columns. If your salary range fell between the one, you are at a specific range# that I created to breakup the search. The other criteria is the row on top that has percentages. Basically, your amount that you receive changes based on where your salary range falls and what % you rate. I have attached a spreadsheet with the example.

Also, if running as a query, not sure what relationship has to be established. Would the salary tie to both the min and max? and how do you have the rows searched as in excel? This will eventually be tied back to an employee roster to calculate total potential benefits for an individual.

Thanks for you help.Allowance Value.zipAllowance Value.zip

[RuralGuy]

Have you looked at the FindFirst function?

[abinjoseph]

If you have any reference or an example video that would be great. Just searched and not finding much about it. Also looked like a lot of coding involved. I would be up for that if there was a few walk through examples to watch or practice with for me to comfortable with it.

[RuralGuy]

Sorry no, but there is a ton of help on the net.
http://allenbrowne.com/tips.html
http://www.granite.ab.ca/accsmstr.htm
http://www.accessmvp.com/strive4peace/
http://www.helenfeddema.com/