summing over a date range from a different table
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
Each of the tables are related by Project number.
Any insight would be great..Thanks.