Where on a Make Table Query can I see what file will be created

[AccNovice]

I am looking at an existing Macro that contains an entry:

OpenQuery - 002 Company Export (This is a Make Table Query)
I looked on the above mentioned query but cannot see what file will be created by this query.

Could somebody be so kind as to point me in the right direction?

 

[namliam]

Go to the database screen and find the query.
Open the query in design mode.

Now there are two options...
1)
In the menu, Query => Make table Query (or find the corresponding shortcut on the menu bar)
A screen will popup to show what table it makes.

2)
In the menu, View => SQL View
Here it will say Select .... bla bla ... INTO Tablename
TableName is what is created.

Good luck

 

[AccNovice]

Thanks you very much - your advice was very helpful.
I tried to add to your reputation but got the following message:

You must spread some Reputation around before giving it to namliam again.

 

[namliam]

I guess I am helping you to much

That is OK tho ...