Can a Query create a new Table?

  • Thread starter Thread starter Bud
  • Start date Start date
B

Bud

I have a need to perform a query on an existing table and take three of
the fields, concatenate them and then create a new table with this
information?

Can this be done with a query?

Thanks
 
Bud said:
I have a need to perform a query on an existing table and take three of
the fields, concatenate them and then create a new table with this
information?

Can this be done with a query?
Click to expand...

Yes. Start with a normal Select query that selects the three fields you
want in whichever records you want. Then just open that query in Design
View and click menu Query/Make Table. It will prompt you to what you want
to call the new table. Finally, click Run Query (the exclamation button in
the toolbar) and it will create your new table.

-Stu
 
I have a need to perform a query on an existing table and take three of
the fields, concatenate them and then create a new table with this
information?

Can this be done with a query?
Click to expand...

Yes - a MakeTable query.

However I really have to question why this operation would ever be
needed in practice. Why do you feel that you need to store non-atomic,
redundant data in a table? If you want to have this concatenated field
displayed on a Form or a Report, you can do so using a simple select
query; there is no need to create a new table!
 
John said:
However I really have to question why this operation would ever be
needed in practice.
Click to expand...

Actually, it's only a temporary table. I need to export the newly
created data to Excel so it can be converted yet again by one of our
vendors for our financial application.
 
Bud said:
Actually, it's only a temporary table. I need to export the newly
created data to Excel so it can be converted yet again by one of our
vendors for our financial application.
Click to expand...

Just export a select query. No need to make a table.
 
Back
Top