I haven't worked much with crosstabs for my needs so not sure why the date parameters aren't working. I really thought they would. Think I will have to work with your data to analyse if you want to provide. Follow instructions at bottom of my post.

Permanently changing the Access query requires VBA code that actually rewrites and saves the definition for the query using the QueryDefs collection.