making new tables

[iuphim]

i heard that you can create a query that makes a new table and also a macro that makes a copy of the link table. does anyone who how to do this?

thanks,

 

[Alansidman]

Once you have created and tested your select query, change it to a make table query. With your query open in design mode, click on query in the menu and select make table.

Alan