How do I not carry over parameters from query to query?

[Guest]

I have a parameter query "Cost by Style" that works wonderfully [Enter
Style].....

I have another query I have based off of the one above "Total Cost by Piece"
(because within each style there are several pieces) - but I do not want to
use the [Enter Style] parameter in THIS query. Since I have based this
second query off the first - my parameter carries over automatically. How
can I stop this? This remains a question if I choose to use the query in a
subform, or report etc.... and I don't want the parameters involved at that
point.... How do I NOT automatically carry parameters over to other objects?
Is this possible? I do have instances (reports) where I need the parameters
to carry over....however I also need the flip side of that in other
forms/queries.

Can anyone help?

 

[John Vinson]

On Tue, 6 Sep 2005 17:17:20 -0700, "Karin S" <Karin

How can I stop this?

By not using that Query.

The parameter is an intrinsic component of the query. You can't tell
Access "oh, I really didn't mean it this time, just forget I asked for
[Enter company]".

Create another query without the parameter, and use it.

John W. Vinson[MVP]

 

[Guest]

Okay well thank you. It seems like wasted effort to create duplicates of
queries, ones with parameters and ones without. Would have thought there
would be a way around that. I'll back up to the design portion and see if
maybe I haven't goofed there. Just a novice....thank you for your help.

Please ignore duplicate question (also wasted effort) that posted this
morning. I had trouble locating my original post.

On Tue, 6 Sep 2005 17:17:20 -0700, "Karin S" <Karin

How can I stop this?

By not using that Query.

The parameter is an intrinsic component of the query. You can't tell
Access "oh, I really didn't mean it this time, just forget I asked for
[Enter company]".

Create another query without the parameter, and use it.

John W. Vinson[MVP]