Macro output to new table

[MKBRAD]

I have a series of queries that supply data to a new table created by one of
the queries. How do I supply the name of the new table to be created so that
the macro continues without input from the user? If I use the "Output to"
then the user will have to supply information....

 

[Jeff Boyce]

Creating a new table is rarely necessarily in a well-normalized relational
database. I usually see this when someone is trying to collect data
together for a report.

If you can already collect the data together (for whatever your purpose)
using a query, just use the query, without having to create a new table.

Or if I've misinterpreted, please provide more info...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.