I have a crosstab query that tells me the number of records of each type per month per type. For example the number of falls for january - july broken down by month. I also have several locations, and I have built separate queries for each location (there are about 100).
I really do not want to build a crosstab query for each of the locations, too time consuming. Is there a way that I can create a parameter query that will ask the user which query (under "table:") that they wish to use.
I hope that is clear enough,
Thanks.
-Z
I really do not want to build a crosstab query for each of the locations, too time consuming. Is there a way that I can create a parameter query that will ask the user which query (under "table:") that they wish to use.
I hope that is clear enough,
Thanks.
-Z
