Calculation

[sparklegrrl]

I posted in General but I think this may belong here.

Basically I have a time table that has a work order ID, employee ID, reg hours, reg rate, ot hours and ot rate.

I want to add 3 fields

regtotal (this should multiply the reg hrs worked by the reg rate)
ottotal (this should multiple the ot hrs by the ot rate)
and
total (this should add the regtotal & the ottotal)

I don't know how to add calculations to fields in a table....HELP!

I can NOT for the life of me figure this out!

 

[Zippyfrog]

I would use a query, and in a query you can create a calculated field doing exactly what you are thinking.

-Chris

 

[sparklegrrl]

I figured as much but I'm not sure how. Also....I have it automatically looking up the reg rate and the ot rate based on the selections in the combo box but it doesn't seem to be storing them properly.

 

[Zippyfrog]

Would it be possible for you to post your database here? I understand what you are trying to do, but it is a lot easier if I can see how the entire database is set up and where exactly you are trying to store the values. Is the database set up so that different employees have different regular hour payrates than others, or is a hourly rate the same for everyone?

-Chris

 

[jfgambit]

Sparkle:

Adding Calculated Fields to a table is an Access "NO NO".

You want to calculate fileds in a query or in a form:

Here is an example for you:

 

[sparklegrrl]

GOT IT! It's all working fine and I added a text box (Exp3) that totals Exp1+Exp2. The query and reports are working fine.

It if formatted as a subreport and I can't figure out how to have the exp 3 from the subreport copy to the bottom of the main report so I can add in with other totals.