Please help with calculation...please

[wvcarpenter]

I must create a small database that calculates wage rates. I am not very
skilled with using access and haven't found a template that I can manipulate
to do what I need.

Scenerio: a person must have both class hours and work hours in order to
claim a wage rate. I will have a table for class hours and a table for work
hours. How owuld I link those to produce a percentage? ex - 200 class hours
+ 1600 work hours = 70% pay rate.

Also is there a way to make a form that will update the total work hours? I
input work hours monthly. Could I make something that would allow me to put
the ID number and that months work hours and it would update that person's
total work hours?

Please help if you can. Or direct me toward something that will give me
some guidance. I'm pretty desperate...I'm doing this in a very poor way now.

Thank you

 

[John W. Vinson]

I must create a small database that calculates wage rates. I am not very
skilled with using access and haven't found a template that I can manipulate
to do what I need.

Scenerio: a person must have both class hours and work hours in order to
claim a wage rate. I will have a table for class hours and a table for work
hours. How owuld I link those to produce a percentage? ex - 200 class hours
+ 1600 work hours = 70% pay rate.

Since you chose not to post any explanation of the table structure, nor an
explanation of how 200 + 1600 corresponds to 70%, nor how the tables are
related, etc. all I can say is "use an appropriate Query joining the tables on
an appropriate field".

Also is there a way to make a form that will update the total work hours? I
input work hours monthly. Could I make something that would allow me to put
the ID number and that months work hours and it would update that person's
total work hours?

Don't *STORE* the totals anywhere. Calculate them on demand. You can use a
Totals query, or put a textbox on a form footer with a control source

=Sum([some field name you haven't told us])

to total the value in that field.

Please help if you can. Or direct me toward something that will give me
some guidance. I'm pretty desperate...I'm doing this in a very poor way now.

If you can give us a bit more information about your database we'll try to
help... just remember, *you* can see your tables; we cannot.

John W. Vinson [MVP]