+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,329
    Thank Post
    1,380
    Thanked 850 Times in 543 Posts
    Rep Power
    639

    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.

  2. #2
    mrtechsystems's Avatar
    Join Date
    Jun 2005
    Location
    Yorkshire
    Posts
    424
    Thank Post
    96
    Thanked 22 Times in 22 Posts
    Rep Power
    25
    What version of Office

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

  3. #3
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    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.

  4. #4
    markj_metcalfe's Avatar
    Join Date
    Jun 2007
    Location
    Sheringham, Norfolk
    Posts
    17
    Thank Post
    0
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    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.
    Attached Files Attached Files

  5. #5
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Quote Originally Posted by markj_metcalfe View Post
    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

  6. #6


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,329
    Thank Post
    1,380
    Thanked 850 Times in 543 Posts
    Rep Power
    639
    Thanks, it was a great help to have the example. So that's working. Can anyone recommend a good Access guide book?

SHARE:
+ Post New Thread

Similar Threads

  1. Command to lookup public IP
    By thegrassisgreener in forum Windows
    Replies: 5
    Last Post: 4th December 2007, 01:31 PM
  2. PHP and IP Address lookup
    By plexer in forum Web Development
    Replies: 0
    Last Post: 27th March 2007, 11:17 AM
  3. DNS Forward Lookup Zone query
    By SpuffMonkey in forum Windows
    Replies: 0
    Last Post: 19th February 2007, 04:20 PM
  4. MS Access
    By wesleyw in forum How do you do....it?
    Replies: 1
    Last Post: 9th November 2006, 09:50 AM
  5. FTP Access
    By ben_hampshire in forum Windows
    Replies: 7
    Last Post: 27th April 2006, 11:44 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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