Hello



I've been dealing with this for a while in many situations.



I'm not sure how to define the SQL of a query, when this query needs to have

the "Underlying" query modified before it is executed.



Here is what I mean by that.



I have TABLE1 and TABLE2



I have QUERY1 that selects criterias for TABLE1 

I have QUERY2 that selects criterias for TABLE2



The result of these two queries are then joined and GROUPED in one FINALQUERY used for the 

report.



In a case like this, in Access or VB, I would simply modify the underlying SQL for QUERY1 and 

QUERY2 with the criterias selected by the user

since these two have to be changed before running the FINALQUERY.



But with ASP, how do I do this? I could change the underlying query for QUERY1 and QUERY2, 

but

if I do that, and another user is accessing the same report at the same time, will it give the 

second

user the wrong result because the SQLs for QUERY1 and QUERY2 were being modified by 

another

user?



Is there another solution?



Robertaccio