Report and Query Parameters (Yet again!)

[jasenpeters]

I'm not sure I understand the use of parameter queries and reports.

I have a query that returns calculations for Categories. There are 6
Categories (A,B,C,D,E,F).
There are also two Types of results Y and Z.

The result may not have all Categories or Types, because there may not
have values yet for a particular Category and Type.
I called this query qryTotals.

Here are the results....

Cat Typ Tot
--- --- ---
A Y 3
A Z 7
B Z 2
D Y 5
F Y 1
F Z 9


I need a report that gives me all Categories for a particular Type.
I would like the report to supply the Type value automatically. (Do not
want to prompt the user)


For example the results would be for Type ='Y'....

Cat Typ Tot
--- --- ---
A Y 3
B 0
C 0
D Y 5
E 0
F Y 1


So, I thought of making another query that gives me all Categories and
if there are no values for a particular Category, set it to zero using
nz(Total).

I created another query like this (pseudo QBE)...

Categories -------> qryTotals (Outer join to include all Categories)

and created a Type parameter in the qryTotals query.

When executed, the new query asks for the Type parameter and the
results are as shown above.


Is there a way to create a report or query that will automatically
supply the parameter to the
first query?

TIA

 

[Guest]

under criteria... use Like "Y"