1 Project has Many Project Forecasts
1 Project has Many Project Tasks
March Forecast for Project 1234--$2000 for March, $3000 for April, $2000 for May
March Forecast for Project 5678--$1000 for March, $1500 for April, $10000 for May
March Forecast for Project 9876--$ 0 for March, $5000 for April, $3000 for May
on the Project Forecast, for each Month-Study Number combination
I would like to summarize:
Total Revenue from Project Tasks
where [Project Forecast-Project Number]=[Project Task-Project Number]
and where [Task-Billable Date] is greater than FirstDayofMonth([Forecast Date])
and less than LastDayofMonth([Forecast Date])
