100 select queries to make a table?! Maybe you should create the table and
then append the records.
Can you explain what you are doing in more detail? There might be an easier
way.
--
Bill Mosca, MS Access MVP
"Tom Tuohy" <Tom
(E-Mail Removed)> wrote in message
news:CD3B0049-DBA8-4DEF-80DB-(E-Mail Removed)...
> I'm attempting to use about 100 select queries for a Make Table query. I
> get
> this message if I try to view any more than 3 of them. How do I avoid
> having
> to make 50 tables?