Calculating costs for a time period

  • Thread starter Thread starter steve
  • Start date Start date
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
 
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
 
Back
Top