put other data from other fields into one field of the same table

T

Tim

I want to put data from other fields in a table into one field in the sam
table. I guess I may have to use an array to store the whole data in the
table and put it in one field. There is no space is allowe between fields.
Thank you,T.
 
K

Klatuu

I can't imagine any good reason to do such a thing. As long as the data is
in the table, you can retrieve it any way you want to. However, if you must
do this, be aware the limit to a text field is 255 characters. A memo field
can store up to 65,535 characters.

You did not say whether the fields you want to combine are in the same
record with the destination field. Also, how you code this will depend on
the number of fields to combine. If it is only a few, then

With MyRecordset
.Edit
!DestionationField = !Field1 & !Field2 & !Field3
.Update
End With

If it is a large number of fields

Lets say we want to combine fields 3, 4, 9, 11, 12, 15 into field 2

strFldList = "03/05/09/11/12/15/"
With MyRecordset
.Edit
For x = 0 to .Fields.Count
If Instr(strFldList,Format(x,"00/") <> 0 Then
.Fields(2) = .Fields(2) & .Fields(x)
End If
Next x
End With
 
Top