We have a forecast table that users update their forecast of total visits on a monthly entry basis for each project (i.e. Proj 1, Jan 2021 = 10, Proj 1, Feb 2021 = 15, Proj 2, Jan 2021 = 20, etc). There is a visits table (not currently related to the forecast) that has an entry for each individual visit that includes that date.
what I am trying to figure out is how to summarize all the visits from that table by project and month into a report or field in the forecasting table so we can provide a report that shows forecast vs actual. Thoughts?
------------------------------
David Berndt
------------------------------
