Create a table based on another table.

I may be in over my head. I am trying to create a table consisting of a
single field based on another table containing seven fields. I need to
combine all seven fields of the first table into the second table consisting
of a single 23 character field. The first table consists of over 5000
records. The second table will be used to upload into another database.

Thanks

On Wed, 6 May 2009 18:10:01 -0700, KJT wrote:

I may be in over my head. I am trying to create a table consisting of a
single field based on another table containing seven fields. I need to
combine all seven fields of the first table into the second table consisting
of a single 23 character field. The first table consists of over 5000
records. The second table will be used to upload into another database.

Thanks

It's neither necessary nor appropriate to create a second table for this
purpose. You can export a Query just as easily as you can export a Table.

You can create a query with a calculated field resembling

AllTogether: [Field1] & [Field2] & [Field3] & [Field4] & [Fieilf5] & [Field6]
& [Field7]

to just jam them all together as is. The result will depend on the nature of
the data - if each field contains just an integer 1, you'll just get a 7-byte
string "1111111", not a 23 character field. What's the nature of the data
you're concatenating? Could you post a sample of the seven field values and
the desired result?
--

John W. Vinson [MVP]

On Wed, 6 May 2009 18:10:01 -0700, KJT
wrote:

That's not a job for a new table, but for a new query. Something like:
select myField1 & "-" & myField2 & "-" & myField3 as myAggregateField
from myTable
(of course you change myObjectNames to yours)

-Tom.
Microsoft Access MVP


I may be in over my head. I am trying to create a table consisting of a
single field based on another table containing seven fields. I need to
combine all seven fields of the first table into the second table consisting
of a single 23 character field. The first table consists of over 5000
records. The second table will be used to upload into another database.

Thanks