Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DLookUp (Access 2000)

    I am getting data out of a table with the help of DLookup function.The data i am getting is numbers.Is there any way to hard code these numbers into words as follows
    If the number is 960 then to read UniLeningrad
    If the Number is 1008 then to read UniMoscow
    in the folloiwng line :
    =DLookUp("Studentid";"Profiles";"Profileid = " & [Profileid])

    For example, in the above example,i obtain on the control of the form, the number 960.And i want to read it UniLeningrad Is it possible ?

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

    Re: DLookUp (Access 2000)

    Are UniLeningrad and UniMoscow the only ones, or do you have a whole list of universities?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DLookUp (Access 2000)

    They are all 10 in number and will hardly increase

    Regards

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

    Re: DLookUp (Access 2000)

    Still, I would create a table with two fields: the numbers and the corresponding university names. You can then use another DLookup.

Posting Permissions

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