"Make Table" Query

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

New user here.

Running a "make table" query from a select query (which I
ran and game me the results I want).

For some reason, when I turn it into a make table query
it "appears" to be doing something, but my (new) table is
not in my database anywhere. I checked to make sure I was
saving the new table in the same database (per the box),
but cannot find it...

Help !!
 
How are you running the make table query?

If you are running it from query design view by clicking the "View" button
on the toolbar, as you might with a regular query, the Access will display
the results of the query, but will not make the table. To get it to make
the table, try clicking the "Run" button (the exclamation mark) on the
toolbar in design view, or by opening the make table query from the Queries
tab of the database window.
 
Back
Top