Using Lookup to Create a new Field

[jtinjr]

Hi,

I am using a database to track student test scores. In this database raw scores are entered, but I would like to be able to calculate the scale score through looking up the scale score in another table.

Right now I have a table designed for entry of raw scores and a static table used just keep track of how to convert the scores to scale scores. I would like to automate the calculation of scale scores.

For example a student score of 28 on test form A is entered into a the raw test score table; I would like to have a scale score field created automatically through looking up the score in the static scale score table.

I know how to do this in Excell using VLOOKUP, but cannot figure this out in Access. Can someone help me or point me to a place where I can learn more about the lookup function in access

Thanks

JT

[ajetrumpet]

What it sounds like you need is a scale score field in the actual table. Put onein, leave the records blank, and when you enter the raw score into your form, put something simliar to this in the AFTER UPDATE event of that box:

me.ScaleScore = _
   dlookup("ScaleScoreField", "ScaleScoreTable", _
           "[RawScore] = " & me.RawScore)

what that does is use that Raw Score on the form to lookup the corresponding scale score record in that table (assuming you are storing it in a different table).