Total Query HELP!!!!

[Fransdekock]

Hi

I'm currently administering a database a previous developer really messed up. I have a problem getiing a total

I have two tables a ResourceTable and a ResourceSub table

The resource table holds information for ResourceID - Primary key StaffID for member of staff projectID for the project he is working on Total days , Fees , Sold Rate

The only thing entered is Sold rate a datasheet form

I have a subform linked on resourceID cause there could be more than one staff working on a project.

With fields Week ending - select from combobox
Days - number of days worked in that week

There could be more than one week record

So what i want to do is to update total days to a sum(days) of the subform
also Fees then will become total days * sold rate.

The way the form is set up i either have to run a update query or use recordsets or is there any other way. Using sum text boxes on both forms is not an optiion I have very little development experience so any help would be much much appreciated!