Parameter Query

[aftabn10]

Hi, I have managed to write a query that has parameters for a [Start Date] and an [End Date] which works fine.

I then run another query based on the results of the first query, but whenever I ran this query, i get the parameters [Start Date] and [End Date] popping up for my 2nd query.

Is it possible to stop this from appearing for my second query?

If somebody could please help. Thanks in advance.

 

[Brianwarnock]

Any query run on the results of another query, ie a query is quoted in the From clause, cause that other query to run.

Query results aren't saved.

Brian

 

[JamesMcS]

You could make the first query a make table, then base the second query on that to get around the problem

 

[Brianwarnock]

Its not a problem, he has to run query1 and enter the parameters anyway, making a table inbetween only complicates matters and then he personally has to run both queries, and then if he runs again... sheesh give me strength.

Brian

 

[JamesMcS]

Well of course he'd still have to run the make table with parameters, but the original question was to get the second query to stop prompting for parameters.

 

[Brianwarnock]

I think that we are supposed to help people understand what is going on , not give them crazy work arounds.

Brian

 

[JamesMcS]

Miaow... I was answering the OP's question mate, nowt more.... A "why is this happening?" would of course have prompted an explanation of the cause. Good answer though, you can never have too much information....

 

[JamesMcS]

Or can you...