S
SAm
Hi
I need to transpose data so i use two CrossTab Queries. i then use a union
to combine them (the value are different, so i need to use two crosstabs). i
then group them, and sum them (this helps combining the data of the Union
Query).
Ok, now here is the question. i would like to run this with VBA so that i
can loop through a list of parameter values. my problem is that i would like
to pass the parameter value to the crosstab query but i call the last
grouping query, how do i do this? any good solutions?
thanks,
Sam
I need to transpose data so i use two CrossTab Queries. i then use a union
to combine them (the value are different, so i need to use two crosstabs). i
then group them, and sum them (this helps combining the data of the Union
Query).
Ok, now here is the question. i would like to run this with VBA so that i
can loop through a list of parameter values. my problem is that i would like
to pass the parameter value to the crosstab query but i call the last
grouping query, how do i do this? any good solutions?
thanks,
Sam