Make Table Query (Hide output)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there. I need to use a number of make table queries to create some interim
tables. Rather than clog up the screen with a bunch of tables, I'd like to
output the table from the query as a hidden table.

Any ideas?
Ta
 
Andy

Often, when folks create a number of interim tables, they do so because they
believe this is the only way they can accomplish what they are trying to do.
If you'll describe what you are trying to do (rather than "how"), the
'groups' readers may be able to offer other appproaches...

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
An alternative to adding the interim tables to your database is to create a
temporary database, put your temporary tables in it, link to them. When
you are finished you can kill the temporary database. This has the
advantage of not bloating your database.

Check out this URL on Tony Toews's site

http://www.granite.ab.ca/access/temptables.htm
 
Back
Top