Results 1 to 4 of 4
  1. #1
    Ahsan.masood is offline Novice
    Windows XP Access 2016
    Join Date
    Mar 2019
    Posts
    2

    Hi. How to put tax monthly figure in my payroll entry form from a table.

    Hi,
    Actually, i got into a problem while designing my payroll database.
    I have a different tax slabs to workout with employee's gross salaries. First, i have designed a tax slabs in my table "Tax Slabs" (Like mentioned below)
    On the other hand i have my payroll data entry table / form.
    Whenever the gross salary reached or exceed to a different tax slabs (mentioned below), i want my payroll entry table / Form to collect the monthly tax figure automatically. Could you please tell me how to do that all. I will be gratefull for your help.



    Gross Pay Tax Slab1 400,000.00
    Gross Pay Tax Slab2 800,000.00
    Gross Pay Tax Slab3 1,200,000.00
    Gross Pay Tax Slab4 2,400,000.00
    Gross Pay Tax Slab5 4,800,000.00
    Gross Pay Tax Slab6 10,000,000,000.00
    Tax Slab1 Percentage 0%
    Tax Slab2 Percentage 0%
    Tax Slab3 Percentage 0%
    Tax Slab4 Percentage 5%
    Tax Slab5 Percentage 10%
    Tax Slab6 Percentage 15%
    Tax Slab1 Fixed Amount -
    Tax Slab2 Fixed Amount 1,000.00
    Tax Slab3 Fixed Amount 2,000.00
    Tax Slab4 Fixed Amount -
    Tax Slab5 Fixed Amount 60,000.00
    Tax Slab6 Fixed Amount 300,000.00
    Tax Slab1 Deduction Per Month -
    Tax Slab2 Deduction Per Month 83.33
    Tax Slab3 Deduction Per Month 166.67
    Tax Slab4 Deduction Per Month -
    Tax Slab5 Deduction Per Month 5,000.00
    Tax Slab6 Deduction Per Month 25,000.00

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Welcome to the forum......

    I would suggest you think about redesigning your table. The way you have it designed has a name - its called "Committing Spreadsheet"
    The current layout is like a spreadsheet - typically short and wide. An Access table is typically tall and narrow.
    You have 6 repeating groups. The problem with this design is if the number of "Slabs" changes, you have to completely redesign your dB - the tables, queries, forms, reports and possibly the code.

    It looks like the table should have a PK field, 6 fields, plus a field the the slab number.



    Here are some links about normalization:

    Normalization
    Normalization Terms and Concepts


    What is Normalization? (there are 5 parts)
    =======================
    What Is Normalization, Part I: Why Normalization?



    Entity-Relationship Diagramming (there are 4 parts)
    ==============================
    Entity-Relationship Diagramming: Part I

  3. #3
    Ahsan.masood is offline Novice
    Windows XP Access 2016
    Join Date
    Mar 2019
    Posts
    2

    Thanks.

    Hi Steeve,
    Thanks a lot for you kind help. I will check these out i hope things get sorted.

    Regards

    Quote Originally Posted by ssanfu View Post
    Welcome to the forum......

    I would suggest you think about redesigning your table. The way you have it designed has a name - its called "Committing Spreadsheet"
    The current layout is like a spreadsheet - typically short and wide. An Access table is typically tall and narrow.
    You have 6 repeating groups. The problem with this design is if the number of "Slabs" changes, you have to completely redesign your dB - the tables, queries, forms, reports and possibly the code.

    It looks like the table should have a PK field, 6 fields, plus a field the the slab number.



    Here are some links about normalization:

    Normalization
    Normalization Terms and Concepts


    What is Normalization? (there are 5 parts)
    =======================
    What Is Normalization, Part I: Why Normalization?



    Entity-Relationship Diagramming (there are 4 parts)
    ==============================
    Entity-Relationship Diagramming: Part I

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Post 3 was moderated, I'm posting to trigger email notifications.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 06-22-2016, 02:21 PM
  2. Replies: 15
    Last Post: 09-01-2015, 12:20 PM
  3. Help with payroll form
    By visidro in forum Access
    Replies: 7
    Last Post: 10-22-2014, 04:49 PM
  4. Employee info in Payroll form
    By ismalee in forum Forms
    Replies: 4
    Last Post: 06-30-2012, 05:16 PM
  5. Replies: 1
    Last Post: 06-22-2011, 07:55 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