By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,990 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,990 IT Pros & Developers. It's quick & easy.

Report based on a crosstab query

P: 14
Hi,

I created a report based on a crosstab query and I need to add some filtering either in the report or in the query but can't find how to do it. For example, my report contains Site Name, Cycle and Results, when the user open the report, I would like him to be able to choose a specific Site Name or all (with a list box that would be even better), I found some ways to do it but they are not efficient and I need to create multiple queries and tables. Any idea?

Thank you

Marie
Jul 31 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,364
Hi,

I created a report based on a crosstab query and I need to add some filtering either in the report or in the query but can't find how to do it. For example, my report contains Site Name, Cycle and Results, when the user open the report, I would like him to be able to choose a specific Site Name or all (with a list box that would be even better), I found some ways to do it but they are not efficient and I need to create multiple queries and tables. Any idea?

Thank you

Marie
Use an intermediary form where they choose what filters they want and the queries/reports pull information from the form.
Jul 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.