Which Query was run?

[DeZiner]

I have 4 queries. Only one will run via if statements based on form input. Is there a way to figure out which one actually ran? They all share the same name. DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[mikeshort]

I don't know exactly what you mean by "find out". You can set a variable inside the IF block with a different value for each version of the query and display it. Or Log it, I guess. If debugging is turned on, you can view the SQL statements at the bottom of the page. Other than that, if they have the same name, there is no easy way to tell.

 

[DeZiner]

That's a great Idea. I can add variable named whatever and set it to different values in each query./ Then check for the value of the variable later.

So easy just looking too deep.

Thanks! DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic