AnsweredAssumed Answered

summing over a date range from a different table

Question asked by kashaev on May 3, 2011
Latest reply on May 27, 2011 by philmodjunk

Title

summing over a date range from a different table

Post

I'm sure this will be easy for most of you...

I have a time billing DB I'm trying to create.  I have a table of time entries based on employee number and project number...I'm trying to figure out how to create a script that will pull (by date range) all of the time entries for a specific project number and give me sums of the hours spent based on employees.  These sums will then be displayed on the invoice to the client and be used to calculate the total for the invoice.  

I have the a

Time entry Table

Project Table

Invoice Table

Each of the tables are related by Project number.

Any insight would be great..Thanks.

Outcomes