Tax Table.

[LaBam]

Can someone out there help me? I’m developing a Payroll System for my office and I would like to use a table to capture the PAYE tax structure (for employees) so that I won’t have to go into the codes/queries to effect changes whenever the tax changes. Of course, the tax changes almost every year. In such a case, the user should be able to call up a form and effect the necessary changes.

I’ve looked at the link below but it does not help. When I used the “Select Top 1” statement, not all the employees were displayed.

http://www.access-programmers.co.uk/forums/showthread.php?t=33568&highlight=compute+tax

Please help.

 

[Pat Hartman]

I would recommend Quickbooks or something similar. You should be able to interface with your Access app if you need to.

 

[LaBam]

You see I have to develop the whole application in Access (company rules!). And I have seen an Access app. doing just that but that was years back and there's no way I can contact the author now.

I need another suggestion please.

 

[Pat Hartman]

Company rules? That's a bit parochial, not to mention fiscally irresponsible. Payroll is a pretty complex application and has been done many times by companies that know all the problems. The point of using a payroll system is that someone else has to deal with the Fed's ever changing rules and the annual (or more frequent) updates to tax tables.

Look at www.databasecreations.com They offer accounting software with an optional payroll addin. The application is built in Access and you can elect to purchase source code so you can make modifications if necessary. If you can't purchase the payroll functions separately, perhaps a web search will turn up other viable candidates.