add record to paytable

[SHETTY]

Hi Friends

I want to know how I can add data to pay table month after month
automatically, may be I have to run a append querry or with the help of
VBA ?
The update to pay table will be based on the attendance leave status etc. I
have written a querry which work out pay for current/running month. How I
can append data returned from querry to pay table with the pay date ?

Actaullay I have created database which works fine for a single month,
reports- generating pay slips all are working fine. But I dont know how to
work on date values (say for a particular period) and updating paytable
automatically as per current month salary

Please guide

Ramesh

 

[Allen Browne]

This is a bigger question than it looks.

There are so many factors, such as payments for full time employees, part
time employees, casual employees, and possibly contractors. Each one has
different requirements (depending on your country's laws), e.g. hourly rate,
overtime rate (possibly tiered), various kinds of leave (annual, public
holiday, ...) some of which could have loadings and some of which is due
(e.g. annual) while others is only as needed (e.g. sick leave) and with
limits. Then there are other factors such as superannuation, public
liability payments, provision for long service, etc, etc. And of course, an
employee can move from one scale to another at any time (e.g. from casual to
part time), and pay rates can change at any time (based on awards or
workplace agreements), and overtime arrangements can vary between employees
or scale, and ...

Does it actually make any sense to try to program this in Access? Please
consider:
- Commercial payroll programs are available for a fraction of the cost it
would take you to develop this (if you value your time.)

- If you do develop it, the maintenance costs could be prohibitive. Whenever
there is a change in law, you must know about it, and ensure your program
handles it.

- Accountants and lawyers are not very forgiving if your program has bugs
(as all untested software does.)

That's not a very technical reply: just an encouragement for you to consider
what you are getting yourself into here.