Summary Query on Results of a Parameter Query

[Fred Zack]

I would like to get means and other summary values from the "table" produced
as a result of a parameter query. But everytime I try to open the parameter
query it ask for the input paramters. Is there any way to save the results of
a parameter query as a table so I can use that as the starting poing for
another query?

Do I have to use SQL? If so how?

 

[John W. Vinson]

I would like to get means and other summary values from the "table" produced
as a result of a parameter query. But everytime I try to open the parameter
query it ask for the input paramters. Is there any way to save the results of
a parameter query as a table so I can use that as the starting poing for
another query?

Do I have to use SQL? If so how?

You can make it into a MakeTable query and create a (redundant, probably
denormalized) table; or - probably better - use a Form to provide the
parameters. Rather than a parameter like [Enter start date:] you could use
[Forms]![NameOfForm]![txtStartDate] and so on; base your statistics queries on
the stored query, and launch them (or reports based on them) from the criteria
form.

John W. Vinson [MVP]