Join Query into a table / make table query

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

Is there a way to make a join query generate a table?

I mean to "save" the join query as a table?

Thanks.
 
Is there a way to make a join query generate a table?

I mean to "save" the join query as a table?

Thanks.
Click to expand...

Yes; in fact, you answered your own question!

Create the Join query. Turn it into a "Make Table" query using the
Query menu option or the query-type icon. Run it using the ! icon.

Generally, however, MakeTable queries are NOT necessary, certainly not
for routine use. They're inefficient and cause rapid database bloating
if you delete the table and recreate it repeatedly. You can use a
simple two (or more) table query as the recordsource for a Form or a
Report, for a mail merge, for export - pretty much anything you can do
with a Table. Are you certain that you need this table?
 
Back
Top