Copied Query Referencing Source Query???

[EricRex]

Hey there,

I have a query named TestQuery that runs fine and gives me the results I want:

SELECT TradeDate, EntryTime, Direction, Symbol, Shares, TrailStop, StopLoss, R10, ATR, ROUND(TrailStop/ATR, 2) AS TS_ATRRatio, ROUND(TrailStop/R10,2) AS TS_R10Ratio, cTradePL, Pattern, Notes, EntryOrder, ExitOrder
FROM StockTrades
WHERE Mistakes LIKE "*Tight*";

Then, I copy that query using Ctrl+C, Ctrl+V and give it a new name, qryTightExitsbyExitOrder.

When I run that copied query, it comes up with a prompt for the TestQuery.Symbol and all of the other values. But there's no reference in the second query to TestQuery!

I've tried this a couple of times and it always malfunctions the same way. Copying and pasting the code into the second query still malfunctioned.

I did get it to work as expected by copying and pasting the code into a new query and saving that new query as the second query name, replacing that second malfunctioning query.

What gives???

Cheers,
Eric

[EricRex]

New wrinkle. I just had this happen on a second, related query. The first one works fine and the copy needs inputs from the first.

One other piece of info: I put * in all of the input prompts and it works as it should.

[pbaldy]

This is a shot in the dark, but open the original query in design view and see if there's anything in Parameters on the Show/Hide tab.

[jojowhite]

delete the new query, qryTightExitsbyExitOrder.
open TestQuery query.
in SQL View, copy (ctrl-C) the SQL string.
Create new query.
on SQL view of the new query, paste the SQL string (Ctrl-V).
Save the new query as qryTightExitsbyExitOrder.

[June7]

I've never encountered that.

Why copy query? Could just rename. So why have a TestQuery object?

[EricRex]

I've never encountered that.

Why copy query? Could just rename. So why have a TestQuery object?

Believe it or not, this fails also! Same result, prompts for TestQuery.Symbol etc values.

[Micron]

Did you quote the wrong post, because that makes no sense to me? FWIW I tried copying a query the same way and giving it a different name. When I run it, it does the same as the original query and does not prompt. I checked both sql statements and they are identical.

[CJ_London]

Perhaps the original query has the filter and/or sort properties populated?

[June7]

Want to provide db for analysis?