Make-Table Query ??

[lstantliff]

Is there a way in a Make-Table query to tell the table to open when it's created? I would assume there is a function or SQL code that would do this, but I know very little SQL. Can anyone point me in the right direction? Thanks!

 

[KeithG]

You could make a macro to run the query then open the table.

 

[lstantliff]

Thanks Keith! I should have thought of that, I had though about a macro, but only to open the table, then I didn't know where to specify that. But using one to do both would work I hope. I will try that.