Quote Originally Posted by June7 View Post
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.