Make Table Queiries within other Queries

[bwuddas]

I am trying to make a "Make Table" query and it appers to "Run" successfully,
expect that no table appers under the Tables section. Further, when I'd like
to try and use the "Make Table" query in another query, it isn't available.
Any ideas as to why?

 

[John W. Vinson]

I am trying to make a "Make Table" query and it appers to "Run" successfully,
expect that no table appers under the Tables section. Further, when I'd like
to try and use the "Make Table" query in another query, it isn't available.
Any ideas as to why?

What's the context? In a production application you should *very rarely* ever
need a MakeTable query. What's the purpose of the new table? Are you running
it by viewing the datasheet (which will NOT actually run it, just give you a
preview of what the output will contain) or using the ! icon?

 

[John Spencer]

Are you running the query or are you simply switching to the datasheet
view? If you just switch to datasheet view then no actual make table
query occurs. Try Query: Run from the menu and see if that creates the
table and adds the records.

You can't use a Make Table query in another query. Make Table creates a
table and populates it. The table and data are not available until the
Make table has completed.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================