Results 1 to 5 of 5
  1. #1
    ract17 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    3

    How can I automatically link the "cost/per hour" values of a worker in a table with a different form

    Hi,



    Im new in using microsoft access.

    I have a table where I enter all the data of the workers in a company incluiding their cost/per hour rate.

    In another table I want to make a database of the daily report of hours that each worker did and obtain the final cost of the hours.

    So I would like that in the form of the daily report,whenever I choose the name of the worker, it will automatically appear to me the cost/per hour rate of that worker.

    I hope it makes sense what Im asking.

    Thanks in advance for your help

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    not sure why you need another table, just use a query as your report recordsource. If this isn't what you want, please provide some example data and an examples of the outcome required for that data

  3. #3
    ract17 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    3
    The procedure that Im thinking in doing is the following:

    1. First, enter the workers data in a table using this form (sorry its in spanish).

    Click image for larger version. 

Name:	form_listado.JPG 
Views:	8 
Size:	32.4 KB 
ID:	25495

    (this is the table where the workers data will be stored)


    Click image for larger version. 

Name:	tabla_listado.JPG 
Views:	8 
Size:	34.4 KB 
ID:	25496



    And what I want is that when Im making the daily report, it appears to me atuomatically the "Clasificacion" and "tasa horaria" values of each worker, whenever I choose their name.



    Click image for larger version. 

Name:	formulario_personal.JPG 
Views:	8 
Size:	78.1 KB 
ID:	25497



    Maybe I can use a query, but Im not sure. I started last week in learning MS access.

    Thanks for your help.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    You have several options.

    if you are choosing a person from a combo box, you can include their hourly rate in the combo box and suppress the column by making it's width 0, then have an additional field on your form that references the column

    Lets say you have a field named Emp_ID that is a combo box.
    Further, let's say your combo box has 4 columns (width 0, 2, 0,0) that contains the Employee Number, Employee Name, Clasificacion and Tasa)_Horaria

    If you want to display the two suppressed fields you would add two additional text boxes and use the control source

    =emp_id.column(2)
    =emp_id.column(3)

    Combo boxes and list boxes are 0 indexed meaning the first column is column 0 when you are referencing it with a numeric value

    The other option is to use a lookup query as described here:
    https://www.accessforums.net/showthread.php?t=61474

  5. #5
    ract17 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    3
    Thanks

    I will try those options

    Best regards!

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

Similar Threads

  1. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  2. Replies: 11
    Last Post: 07-20-2015, 06:07 PM
  3. Replies: 6
    Last Post: 07-25-2014, 09:25 AM
  4. Replies: 1
    Last Post: 01-09-2014, 10:34 AM
  5. Replies: 2
    Last Post: 04-10-2013, 02:59 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