Lookup Value in Table (Acc2K)

Topic

New Reply

I have a table with 3 fields – Degree, Step, Salary.
There are 3 Degrees – Bachelor, Master, Master+30.
There are 18 Steps.
Each degree’s salary is determined by the step.
How do I lookup the degree and step for a teacher to arrive at the listed salary?
It is similar to a Vlookup function in Excel, but I am stumped as to how to accomplish this with Access.

Thanks!

Reply | Quote

Replies

In your teachers table, you have Degree and Step fields, I presume.

Create a query.
Add the teachers table and the salaries table.
Link them by the Degree and Step fields (drag Degree from the teachers table to the salaries table and drop it on the Degree field; drag Step from the teachers table to the salaries table and drop it on the Step field)
NOTE: if you have already linked the teachers and salaries tables in Relations, this step is not necessary.
Add teacher info (name, …) from the teachers table to the query grid.
Next add the Salary field from the salaries table to the query grid.

You can use this query in forms and reports.

You can also use the DLookup function, but it’s much slower than using linked tables in a query.

Reply | Quote

Thanks for the reply. You’ve helped me come to a solution….

Reply | Quote