Results 1 to 3 of 3
  1. #1
    CLHastopper is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    1

    Training or help with set up

    This is probably pretty simple but I haven't worked with ACCESS since my college days over 15 years ago and am struggling to relate some fields. Is there training out there I could take a few hours out of my day to look over and follow some tutorials or work examples?



    Excuse me for my ignorance on Access but I think it's a tool to greatly help budgeting and financial reporting out.

    I am trying to figure out the best way to set up a work order report for all of my employees. What I want is to keep it simple, the fields will only be Date, Employee Name, Work Performed, Hours and Cost. Date is standard, Employee Name will be a drop down list of all the employees BUT I WANT to associate a hourly rate to their name. Work Performed will be a drop down list I can create. Hours will be numerical and then the Cost should be Hours multiplied by the Employee Name (since it should relate to their hourly wages). Is this possible?

    The idea is at the end of each month or year I can run a report for Work Performed and find the total cost for that item.

    Thanks in advance.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Lots of good references in post #3: https://www.accessforums.net/showthr...133#post352133
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    You should not associate Employees hourly pay in the same table.

    You would need a table to record Hourly PayRates as this rate would change over time.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Training Database Bug - Please help!
    By Khermann in forum Misc
    Replies: 3
    Last Post: 06-23-2016, 10:32 AM
  2. Replies: 1
    Last Post: 06-18-2014, 12:19 AM
  3. staff training data base, training
    By SAJAN in forum Forms
    Replies: 1
    Last Post: 09-22-2012, 05:09 AM
  4. Online Training
    By lspelman in forum Access
    Replies: 2
    Last Post: 05-07-2011, 04:30 PM
  5. VBA Training
    By nywi6100 in forum Access
    Replies: 1
    Last Post: 10-26-2006, 10:24 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