date.
I have made a qry to group on date and count the number of enrolments for a
particular day.
What this doesnt give me of course are days where there were no enrolments
ie there are gaps in the dates.
Ideas would be welcome as to how I might get the missing days. My own
thought would be that I might need to store a table of days and then look
for all the days in the date table and those from the enrolment table but
that would require populating a new table and repopulating it with the new
days every time the query parameters are changed.
The query only looks at an intake day as a parameter to give the enrolment
dates over a 20 week period. ie criteria on Enrolment date :
=dateadd("w" , -20, [Intake Day] And <=[Intake Day].
This query will be used to get cumulative values over a set period so that
the school can build historical data and forecasts of student bookings.
Thank you in advance
Peter Bailey