Well, that gets complicated in CROSSTAB.
Review this info on CROSSTAB dynamic parameters http://allenbrowne.com/ser-67.html#Param
And this http://allenbrowne.com/ser-62.html - go to section at end about query dynamic parameters referencing form controls that might not have input.
An alternative is to use VBA DAO methods to modify query objects.
Thanks I will look through that. Actually the more I think about it I think these are the 3 scenarios.
Active and Future
Active, Future, Complete
Complete
I will read those and see what I can figure out.