Converting queries into tables

[Layth]

Hello I have a database project where I have made multiple queries based on multiple tables, I need to know how to export these queries into new tables so that the queries' previous relationship with original access tables remains intact. Any information on how to do that would be appreciated.

Thank you,

Layth

 

[dhookom]

You can create a maketable query based on another table. I really hope you know what you are doing when creating redundant records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[achillese]

Use TransferDatabase function and/or in conjunction with macro.

 

[achillese]

You can also use a Report and set the destination to a file.

 

[Layth]

Thanks so much for the help thus far I believe with your help that I have figured out my problem