Hello All -
Here is my SQL for this query:
/SELECT [Q_OH-IFC_CO].ACTUAL_FINISH, Q_FiRM_PROJECT_DATA.POLE_COUNT_PER_SECTION
FROM Q_FiRM_PROJECT_DATA LEFT JOIN [Q_OH-IFC_CO] ON Q_FiRM_PROJECT_DATA.PROJECT_ID = [Q_OH-IFC_CO].PROJECT_ID
WHERE ((([Q_OH-IFC_CO].ACTUAL_FINISH)>#1/1/2018#) AND ((Q_FiRM_PROJECT_DATA.PROJECT_TYPE)="OH") AND ((Q_FiRM_PROJECT_DATA.JOB_TYPE)="Reconductor" Or (Q_FiRM_PROJECT_DATA.JOB_TYPE)="Long Span"))
ORDER BY [Q_OH-IFC_CO].ACTUAL_FINISH;/
FYI:
- The count is in whole numbers
- the finish dates have a format of 1/1/2018
What I am trying to do is get a simple cumulative (running) total of the (pole) count that is grouped by month. I don't need the year in there since the cumulative total starts in January and runs to december 31st and then I will move the ">" date to the next year. I am trying to get this data to be my source data for an excel line chart.
I have tried for hours to figure this out. I have tried using Dsum to get the cumulative total but then can't figure out how to break it out by month. I am not sure what I am missing.
Thanks for the help.