Compare field in one table to field in another for result

[Licore]

I am creating a report listing. In one table I have a field called position level which is associated with an individual. In another table I have a table listing (salary base rate) of position levels. I want to be able to look at the position level asscociated with the individual and go back to the salary base rate table and do a look up and pull back a salary number.
For example:
Dave Smith Position level is 17
Salary Base Rate table shows this:
Position Level Mid Range
15 28,300
16 30,000
17 31,500
18 33,200

I want the result to pull back the 31,500 amount in my report. I've tried using an IIf statement, but can't get the key elements together. I tried a lookup, but not sure how that works.
Any help is appreciated.
Thanks, Darcy

 

[GoDawgs]

In the recordsource for your report you should be able to link your two tables with position level in them (and link them by position level I mean)...this will let you pull up the name field and the salary field on the report and they should be correct...don't know if you need me to walk you through that more, but if so just let me know. Hope that helps.

Kevin

 

[Licore]

I think I need some help with this one.
You can reach me by email
darcy.szabo@railquest.com

thanks