Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2000
    Location
    Hellertown, Pennsylvania, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lookup Value in Table (Acc2K)

    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!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup Value in Table (Acc2K)

    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.

  3. #3
    Star Lounger
    Join Date
    Dec 2000
    Location
    Hellertown, Pennsylvania, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup Value in Table (Acc2K)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •