Lookup a value in Access

[laserblazer]

I used to be a bit of a wizard with DBase but I find it difficult to get my head around Access. I'm creating a tracking database that contains pupil NC Grades and I want it to automatically allocate the Point Score from the grade. In Excel I'd use a lookup and I guess it's the same in Access. The Point Score is a direct relation to the NC Grade so

 

1c = 7

1b = 9

1a = 11

2c = 13

2b = 15

 

and so on up to 6a = 42.

 

I suspect this is easy if you know how so if anyone can point me in the right direction please.

 

Thanks in anticipation.

[mrtechsystems]

What version of Office

 

Do you not create a lookup field in the design of the database

[apeo]

Not entirely sure what your database looks like so i may be way of but why not just create a table for it so each NC grade is a record in the table.

[markj_metcalfe]

Hopefully this is what you are looking to do. (see attached).

 

There are two tables one with the NCGrades and scores. The other will hold the score allocated to the pupil.

 

The form has two controls on it. Both are bound to the NCScore field in tblstudentscore. The combobox uses a simple select query to show the data. When the NCGrade is selected it will automatically put the score into the student record.

NCGradeLookupDB.zip

[apeo]

Hopefully this is what you are looking to do. (see attached).

 

There are two tables one with the NCGrades and scores. The other will hold the score allocated to the pupil.

 

The form has two controls on it. Both are bound to the NCScore field in tblstudentscore. The combobox uses a simple select query to show the data. When the NCGrade is selected it will automatically put the score into the student record.

 

Lol how cool of you to spend the time to create an example

[laserblazer]

Thanks, it was a great help to have the example. So that's working. Can anyone recommend a good Access guide book?