How do you do....it? Thread, Lookup a value in Access in Technical; I used to be a bit of a wizard with DBase but I find it difficult to get my head ...
18th January 2008, 09:16 AM #1
Lookup a value in Access
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.
IDG Tech News
18th January 2008, 10:39 AM #2
What version of Office
Do you not create a lookup field in the design of the database
18th January 2008, 10:48 AM #3
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.
18th January 2008, 10:54 AM #4
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.
18th January 2008, 11:06 AM #5
Lol how cool of you to spend the time to create an example
Originally Posted by markj_metcalfe
18th January 2008, 12:56 PM #6
Thanks, it was a great help to have the example. So that's working. Can anyone recommend a good Access guide book?
By thegrassisgreener in forum Windows
Last Post: 4th December 2007, 02:31 PM
By plexer in forum Web Development
Last Post: 27th March 2007, 12:17 PM
By SpuffMonkey in forum Windows
Last Post: 19th February 2007, 05:20 PM
By wesleyw in forum How do you do....it?
Last Post: 9th November 2006, 10:50 AM
By ben_hampshire in forum Windows
Last Post: 27th April 2006, 12:44 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)