Subform Totals and Sums

[khunter]

I am trying to create a small database to handle tool work orders for our shop. Currently the sum and totals are giving me grief. I am a neophyte with this so bear with me.

I have two tables, the first keeps the infomation regarding the work order. The second holds information regarding the Design Labor for the work order.

I would like to have a function to total the hours as well as total the hours and then multiply them by a fixed rate of $32.

I have a main form(table1) and a subform(table2). I cannot seem to get the subform to post the information to the main form though.. I have tried using the DSUM function, but I only want to display the total and sum for the current recordset.

Any thoughts?
Attached is the db.

Thanks,

 

[khunter]

Ahh hah, after read more from a search here, I learned that you need to put the sum in the subform and then you can call the information back using the control name.

 

[trucktime]

Total Cost

khunter,

I put an unbound field in the footer of the subform, it totals the hours.
The Total Hours field on the main form is getting the info, multiplied by 32 it gives the Total Cost.
You may want to ad another field for the hourly rate, set the Default Value to 32. That way it will be easier to change the rate.
Good Luck. Trucktime

 

[mugen_rsx]

I am working on something very similar to this example. Mine is calculating on salary. Main Form is Staff infomation, Sub Form is worker done in this month and how much they earn of each tasks. So on this form, I calucate how much they earn in this month. Is it possible to save the total Money earned? Because I would like to use it in another form!

I am trying to create another form here. This form would have all employees name, and how much they earn this month.