Calculate totals from indetermanite number of records

[gcomp]

Here is my scenario: I have a project that has details stored in table1. These details are entered using form1. Some of these details are the amount of time spent on the project and the project number. I have several employees who will enter the project number into form2 as well as the amount of time spent on the project. These details are stored in table2. I want the calculated time results to appear in form1. The calculation will add all of the time spent on the project by any employees who worked on it. There are 20 employees. One may work on the project or 20 may. I have no way to determine who or how many will work on the project. The only thing that will tie it together is the project number. Can anyone out there help?

 

[vbaInet]

Welcome to AWF!!

Form2:
1. I'm guessing the Project Number is supposed to be unique?
2. There can be duplicate Project Numbers?
3. The Project Number will be typed in each time as opposed to it being selected? This is prone to error.

 

[gcomp]

Yes the project number will be unique, although that number may be selected several times by different employees to enter their time on that project. The project number will be selected via a combo box with drop down selection fed from a table. The only thing tying all of the separate time sheets together will be the project number.

 

[vbaInet]

Right. So you need the SUM of all the times first of all. You will SUM per group, your group being Project Number. Have a look at this:

http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx#BM3

 

[gcomp]

Thank you very much, it worked perfectly! I'm a network guy and can work miracles with routers, switches and the like, but when it comes to Access, I feel like a fish out of water sometimes. Thanks again, but I'm sure I will have many more questions.

 

[vbaInet]

No problemo. Looks like you networked your report with the tables successfully

Good luck!