Query mods

[Sayanta]

Hi All,

I am looking at a way to modify already-built query by another query.
I know that you can modify tables through queries, but is there anyway to
modify a query through another query ?
By modify, I mean by changing the structure, criteria, joins etc.

I would be great if anyone could suggest a solution.
Thanks in advance

 

[Michel Walsh]

Hi,


A query does not contain data by itself, but can be used as if it was a
table. Another query can thus build over an existing query, but cannot
"modify" the "SQL code" defining the other query.


Hoping it may help
Vanderghast, Access MVP