Re: Calculate totals for period of time

I think you need to create the daily data.

Maybe write a select query to get the company name, the project name, the
start date, the end date and number of people.

Then walk that recordset with something like.

While not rs1.endEOF
For x = startdate to endate
rs2.append
Assign company, project etc to the fields of the new table
x = x +1
Loop
rs1.movenext
Loop

That would leave you with a table with all your data recorded by individual
calendar days.
In the process you could screen out weekends etc as you like.

By the way I assume their is some companyID in theTblPersonnelDates? Else
how do you associate the hours to a company or is each project exclusive to
one company?

"Mayhem05" <EJHansen05@xxxxxxxxx> wrote in message
news:1158254702.164091.53980@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm hoping someone can guide me on solving this vexing problem I have
with a database I built to track a projects. I'm using MS Access 2003
and here are the basics: the database is designed to track companies
that are supporting projects and the number of personnel in each
company that supports each project. I'm stuck when I want to sum the
total number of personnel supporting the project over a period of time.
For example:
Company A provides 10 people between 1 Aug 06 and 10 Aug 06
Company A provides 15 people between 11 Aug 06 and 20 Aug 06
Company B provides 12 people between 5 Aug 06 and 12 Aug 06
Company C provides 22 people between 9 Aug 06 and 16 Aug 06
Company C provides 28 people between 17 Aug 06 and 28 Aug 06



.