Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2021
    Posts
    3

    Project wise weekly timesheets

    Anyone please (PLEASE PLEASE) help me, I am new in MS access<br><br>I would like to have Weekly timesheet database based on below form, I have Employee table, Timesheet Table, Project Table and Workstage Table.&nbsp;<br>Data will be enter as per below form 1<br>Output FINALTABLE needs to have below information after I enter data in form 1
    Main Form 1: Data form
    Need the output database table as : TIMESHEETDATATB
    I will share my files by email as this apps not allowing to attached file, Please help for access database.

    Please help - 00971553667362
    Thank you - Dilip Gonsalves


    email:dilipgonsalves@gmail.com

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can design the form anyway you want,
    but the data table should be like this:

    EmpID, workDate, Hrs, WorkType


    worktype: RegHrs, OtHrs, DblOtHrs
    may or may not be needed depending on yr needs. It may be possible to calculate based on sum of hrs for that day, etc.

  3. #3
    Join Date
    Apr 2021
    Posts
    3
    Thank you Ranman for your revert,
    My need was to have weekly timesheet with project information he worked during week and the HRS he spending on project. I informed in my msg that I am new to access and any help will be appreciated (in form as you mentioned below)
    ---
    Quote Originally Posted by ranman256 View Post
    you can design the form anyway you want,
    but the data table should be like this:

    EmpID, workDate, Hrs, WorkType


    worktype: RegHrs, OtHrs, DblOtHrs
    may or may not be needed depending on yr needs. It may be possible to calculate based on sum of hrs for that day, etc.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Have a look at the Time Card template in Access. Also Google.

    https://duckduckgo.com/?t=palemoon&q...mplates&ia=web

    That should give you something to start with.?

    I doubt anyone is going to write it for you, which is what you appear to be asking/expecting?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Join Date
    Apr 2021
    Posts
    3
    Thank you Welshgasman,
    I viewed the site but its was not I am looking out for. Thank you

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by dilipgonsalves View Post
    Thank you Welshgasman,
    I viewed the site but its was not I am looking out for. Thank you
    And the templates?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Year wise Date spliting
    By rohinikrishna1987 in forum Access
    Replies: 9
    Last Post: 12-12-2020, 11:07 AM
  2. Count row wise fields query
    By kid in forum Queries
    Replies: 1
    Last Post: 07-18-2020, 09:46 AM
  3. Replies: 1
    Last Post: 05-05-2015, 01:19 PM
  4. Need Query Formula to Remove OT from Timesheets
    By kagoodwin13 in forum Queries
    Replies: 5
    Last Post: 11-13-2014, 11:15 AM
  5. minus date wise sales a=n?
    By alex_raju in forum Access
    Replies: 1
    Last Post: 07-30-2011, 01:23 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