Daily normal and overtime rates

[michb]

I need to be able to calculate on a daily basis, both normal and
overtime hours for both payroll and job costing.
I also then need to calculate the above on a weekly basis, in order to
complete the payroll.

I have employee normal, time/half and double time rates in $value in
one table, then in another I have log in and out times; then another
job start and stop time.

I realize the code is probably logical-but I am not brilliant with
access and have trouble with the nitty gritty!!

Any help greatly appreciated.

Thanks in advance for the help.

[Steve Jorgensen]

On 11 Aug 2005 21:40:42 -0700, mi***@westnet.com.au wrote:

I need to be able to calculate on a daily basis, both normal and
overtime hours for both payroll and job costing.
I also then need to calculate the above on a weekly basis, in order to
complete the payroll.

I have employee normal, time/half and double time rates in $value in
one table, then in another I have log in and out times; then another
job start and stop time.

I realize the code is probably logical-but I am not brilliant with
access and have trouble with the nitty gritty!!

Any help greatly appreciated.

Thanks in advance for the help.

The thing to realize is that databases are not really good at these kinds of
calculations, so what you usually want to do is write code that reads the data
from the tables, computes the overtime, and writes it out to another table.

[michb]

Steve Jorgensen wrote:

On 11 Aug 2005 21:40:42 -0700, mi***@westnet.com.au wrote:

I need to be able to calculate on a daily basis, both normal and
overtime hours for both payroll and job costing.
I also then need to calculate the above on a weekly basis, in order to
complete the payroll.

I have employee normal, time/half and double time rates in $value in
one table, then in another I have log in and out times; then another
job start and stop time.

I realize the code is probably logical-but I am not brilliant with
access and have trouble with the nitty gritty!!

Any help greatly appreciated.

Thanks in advance for the help.

The thing to realize is that databases are not really good at these kinds of
calculations, so what you usually want to do is write code that reads the data
from the tables, computes the overtime, and writes it out to another table.

that is great if you understand and know the code required to enable
you to do this.

[Steve Jorgensen]

On 11 Aug 2005 22:34:00 -0700, mi***@westnet.com.au wrote:

Steve Jorgensen wrote:

On 11 Aug 2005 21:40:42 -0700, mi***@westnet.com.au wrote:

>I need to be able to calculate on a daily basis, both normal and
>overtime hours for both payroll and job costing.
>I also then need to calculate the above on a weekly basis, in order to
>complete the payroll.
>
>I have employee normal, time/half and double time rates in $value in
>one table, then in another I have log in and out times; then another
>job start and stop time.
>
>I realize the code is probably logical-but I am not brilliant with
>access and have trouble with the nitty gritty!!
>
>Any help greatly appreciated.
>
>Thanks in advance for the help.

The thing to realize is that databases are not really good at these kinds of
calculations, so what you usually want to do is write code that reads the data
from the tables, computes the overtime, and writes it out to another table.

that is great if you understand and know the code required to enable
you to do this.

Before worrying about how to code it, figure out what it is you're supposed to
do. "Compute overtime" is no where near a complete enough spec. to start
writing.

First, there are the simple algorithminc requirements. How is overtime
computed? How is this affected by holidays, vacation, and sick days? What
about part-time employees?

Next, what is the work flow that the user expects? When are hours entered,
and when are they reported? What happens if an adjustment must be made after
payroll is generated, etc.?

If your employer or client can't give you a complete spec, then ask to walk
through the process with him or her, so you can see first-hand what workflow
steps are involved.