crosstab parameter query

[silentlyaria]

Hi, is there a way to create a parameter cross tab query in MS Query and bring it into excel? I can't seem to get MS Query to recognize the query and if I create the crosstab parameter query directy in Access and try to import into Excel I get ODBC error (Too few parameters) because ODBC doesn't support pass through of parameters.

I know that there is a way to do this via VBA, but I really like the "Fill down formulas adjacent to data" feature that is available to me if I just use the MS Query way of doing things. Am I even correct in my assumption that the fill down formulas feature is not readily available in vba (without directly coding it)?

Thanks for the help!