Make Table Query

  • Thread starter Thread starter PSULionRP
  • Start date Start date
P

PSULionRP

Novice to Microsoft Access.

How can you tell what Table is created from a Microsoft Access make Table
Query?

I've inherited this Microsoft Access Database with all these make Table
Queries and I've been digging around to see what tables are created by them
and can't seem to find that answer.

Thanks in advance for your review and help.

PSULionRP
 
PSULionRP,
In your SQL statements, the INTO of a Make-Table query would indicate
the make table's name.
or
In query design mode, select View - SQL View to see the SQL statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Novice to Microsoft Access.

How can you tell what Table is created from a Microsoft Access make Table
Query?

I've inherited this Microsoft Access Database with all these make Table
Queries and I've been digging around to see what tables are created by them
and can't seem to find that answer.

Thanks in advance for your review and help.

PSULionRP
Click to expand...

I hope you're asking in order to figure out how to get RID of all these
make-table queries. Such queries will be very rare indeed in a properly
designed production database!

Al's got your direct answer.
 
Back
Top