Calculating costs for a time period

S

steve

I have a database which has calculates labor cost on a project. Part
of the labor table is as follows:
names rates startdate enddate

From this I can calculate the total projected cost to my project.


What I would like is to know how much it will cost me for each month.


How can I achieve that.

Thanks

Steve
 
M

May

SELECT DatePart("m",[enddate]) AS [Month], Sum
(Table2.Rate) AS SumOfRate
FROM Table2
GROUP BY DatePart("m",[enddate]);

May
MCP in Access and SQL Server
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Shop Client delays in my ghantt chart so i can claim for delays 0
Creating Summary Reports from Two Tables 2
allocate resource over long period of time 0
Multiple If statements, Calculating quarterly % holding costs 0
Spread Project Costs Over Months Using Bell Curve 2
Calculating two costs in Project 2003 2
Worksheet design: How to allocate costs to plants? 0
How to track labor cost comsumption against budget task 5

Top