p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   How to prepare a payroll using Access (http://p2p.wrox.com/showthread.php?t=42544)

damanka2001 May 15th, 2006 03:15 AM

How to prepare a payroll using Access
 
Am trying to use Access to prepare a payroll as an assignment but the problem is I dont no the commands to use or how to do it.
This is how the calculation of TAX is to be done in the payroll;

CHARGEABLE RATE TAX CUMULATIVE CUMULATIVE
INCOME(MONTHLY) CHARGEABLE INCOME TAX
1.FIRST ¢200,000 FREE NIL ¢200,000 NIL
2.NEXT ¢200,000 5% ¢10,000 ¢400,000 ¢10,000
3.NEXT ¢1,000,000 10% ¢100,000 ¢1,400,000 ¢110,000
4.NEXT ¢6,600,000 17.5% ¢1,155,000 ¢8,000,000 ¢1,265,000
EXCEEDING ¢8,000,000 @25%

TAX COMPUTATION

TAX= 0.0 + 0.5 X (INCOME - 200,000)
TAX= 10,000 + 0.10 X (INCOME - 400,000)
TAX= 110,000 + 0.175 X (INCOME - 1,400,000)
TAX= 1,265,000 + 0.25 X (INCOME - 8,000,000)

CAN SOMEONE PLEASE HELP ME WITH IT?
THE FUNCTIONS AND EXPRESSIONS TO USE FOR SUCH A PROJECT.
THANK YOU




   Topic



mmcdonal May 15th, 2006 01:48 PM

Did you get this yet? Why would you get an assignment if you weren't taught the technique?

You can do this in a report with the Detail's On Format property.



mmcdonal

damanka2001 May 19th, 2006 07:28 AM

ok. thankx
but can you help me with it?9


Ashfaque May 20th, 2006 07:24 AM

Dealing with this subject is not a matter of short process. You should have sound knowledge / idea of the Access / VBA.

You will have to consider many things before you get the final amount of the Salary. And you MUST NOT go with wrong calculation as it is a matter of money that gets by employee after 30 day's hard-work. So take care of this.

There will be lengthy list of expressions, logics and tricks that you will use in development of the above system such as Select Case, If-Then-Else, Do While etc..

First you create your database and define everything that you need. Design the forms based on the queries, write events behind the form to perform tasks. Then the turn comes to ask the help on above topic.

Good Luck,
Ashfaque


All times are GMT -4. The time now is 06:09 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.