Hi
How do i pass parameters to a query from a VBA. I am looping through a few sets of parameters.
a bit more of what i am doing:
I am using two CrossTab Queries, and then I use a union to combine them (the value are different, so i need to use two crosstabs). Then I group them, and sum them in another query (this helps combining the data of the Union Query). so there is a total of 4 queries.
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 in VBA i call the last grouping query, how do i do this? any good solutions?
thanks,
Sam
How do i pass parameters to a query from a VBA. I am looping through a few sets of parameters.
a bit more of what i am doing:
I am using two CrossTab Queries, and then I use a union to combine them (the value are different, so i need to use two crosstabs). Then I group them, and sum them in another query (this helps combining the data of the Union Query). so there is a total of 4 queries.
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 in VBA i call the last grouping query, how do i do this? any good solutions?
thanks,
Sam
Last edited:
