Results 1 to 4 of 4
  1. #1
    cesarone82 is offline Novice
    Windows 11 Access 2016
    Join Date
    Jun 2009
    Posts
    25

    Select a certain field of a record based on ID

    Hello everyone, I must apoligize in advice for my bad english.



    I create a mask where i want to show (in a text field) a field of a record, but i need to show the particular field of a record whose another field is a particular number. Example

    ID description
    1 20
    2 30

    In the control i must multiplicate the description of the record whose id is 1 with other numbers? how can i do that?
    In excel i'd have used a vertical search but i don't know how to do that in access,

    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    How about showing us what the results would look like in your example?

  3. #3
    cesarone82 is offline Novice
    Windows 11 Access 2016
    Join Date
    Jun 2009
    Posts
    25
    Thanks for the reply. I have this tab;

    ID Price
    1.4 5,0

    1.5 6,0
    .
    .
    .
    In my mask i have a box where i have to perform a calculation with the price associated with a particular iD. example

    ID 1.4
    in a box i need: 5,0*costant

    I found dlookup working searching on internet, i am a newbie, i wonder if this is the best way of doing this.
    In my case i have a tab with various codes and associated quantities, and i have another tab with price for those codes, this is my case.
    Is this the best way?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If it works for you, it is a good way.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. query - criteria based on another row field value
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 05-29-2009, 04:17 PM
  2. Replies: 1
    Last Post: 03-01-2009, 09:53 AM
  3. Replies: 1
    Last Post: 02-26-2009, 11:31 AM
  4. Adding a record based on combo
    By cjamps in forum Forms
    Replies: 1
    Last Post: 02-24-2009, 12:01 PM
  5. Need help - Record set based on a program variable
    By ericargent in forum Programming
    Replies: 1
    Last Post: 09-19-2007, 08:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums