Unknown Action Query

[jasmjohn]

Is there a way to tell what an action query does just by looking at it?

 

[pr2-eugin]

Hello jasmjohn, Welcome to AWF

You mean from the Query window? It is possible. The symbols are quiet self explanatory.

 

[jasmjohn]

Thanks,

This query was designed by someone else, and I am trying figure out what it will do in my database before I run it.

I was thinking maybe there would be some clues in the design view?

 

[pr2-eugin]

Well if you get the SQL, we can get that easily,

Or if you recognize the symbols you should be good to go too.

 

[namliam]

in the database window you can quite easily tell if its an append or delete or create table AQ.

Same in design window, you can see by what "button" is pressed what it does.
If its an append or create table AQ you can click the button to find where it will add/create the table.