Office 10 Crosstab query with Parameters

L

Lydia

I have a large table with records for multiple units and month. I need
to generate output for each unit/month combination. So far I have
these 2 queries:

1: A GroupBy query with 2 paramenters (Enter Unit / Enter Month)
2: A CrossTab query that looks at Query 1. This has the 2 parameters
defined in the SQL

Problem: When I execute the crosstab query I am often prompted
multiple times for the unit/month. The results do seem to be accurate,
but I'd like to get rid of the extra prompts since I will be giving
these queries to unit staff to run. It "seems" to be prompting first
for the standard parameter prompts in the GroupBy query, then again
for the parameters entered into the CrossTab query.

I have tried eliminating the GroupBy query, but the CrossTab
parameters don't seem to do anything when left to their own
devices.... I end up with all units/months in the result.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incone & Expenses Statement 0
Creating a Chart on form from selected data in query. 0
Crosstab Graph Report not showing Parameters in text box 3
Using select and crosstab queries on one report 1
Parameters with mor than one crosstab query in a report. 8
Crosstab query with changing column headings 5
Duplicate prompts in crosstab query and subsequent report 1
Crosstab queries and reports 1

Top