SELECT [Billing Hours All].Project, Sum(CCur([BillableHours])*([InvoiceRate])) AS [Total Invoiced], Sum(CCur([BillableHours])*([BillingRate])) AS [Total Contractor Pay], Sum([Billing Hours All].BillableHours) AS [Total Hours Billed], Sum(CCur([BillableHours])*([BillingRate])) AS [Current Contractor Pay], Sum(CCur([BillableHours])*([InvoiceRate])) AS [Current Month Invoice], Sum([Billing Hours All].BILLABLEHOURS) AS [Current Month Hours]
FROM [Billing Hours All]-
GROUP BY [Billing Hours All].Project;
The bold part of sql is what I need help with want it to filter data in table for last month data for each category- Contractor Pay, Month Invoice, Current Month Hours by Project
I have the first part for Totals working- Total Invoiced, Total Contractor Pay, Total Hours Billed- by Project
Thanks,