K kholm Registered User. Local time Today, 13:28 Joined Jun 25, 2001 Messages 63 Jul 8, 2002 #1 I would like to combine the data that is in multiple fields into one field. How would I go about this. Kristin
I would like to combine the data that is in multiple fields into one field. How would I go about this. Kristin
F fernin8r Registered User. Local time Today, 13:28 Joined May 28, 2002 Messages 142 Jul 8, 2002 #2 Could you give me a little more info? What type of fields are they? maybe an example. Are the fields in the same Table?
Could you give me a little more info? What type of fields are they? maybe an example. Are the fields in the same Table?
K kholm Registered User. Local time Today, 13:28 Joined Jun 25, 2001 Messages 63 Jul 8, 2002 #3 more info The fields are from the same table. When the info is imported from a text file, it is comma delimited and separates each one, but I need all 10 fields to be one. If I could do this in the table level or query level, that would work.
more info The fields are from the same table. When the info is imported from a text file, it is comma delimited and separates each one, but I need all 10 fields to be one. If I could do this in the table level or query level, that would work.
P Pat Hartman Super Moderator Staff member Local time Today, 08:28 Joined Feb 19, 2002 Messages 47,602 Jul 8, 2002 #4 You should not store the combined field. You can concatenate the columns whenever you want to in a query. Select Fld1 & Fld2 & Fld3 As Mush, ... If you want delemiters between the fields - Select Fld1 & "," & Fld2 & "," & Fld3 As Mush, ...
You should not store the combined field. You can concatenate the columns whenever you want to in a query. Select Fld1 & Fld2 & Fld3 As Mush, ... If you want delemiters between the fields - Select Fld1 & "," & Fld2 & "," & Fld3 As Mush, ...
F fernin8r Registered User. Local time Today, 13:28 Joined May 28, 2002 Messages 142 Jul 8, 2002 #5 What i understand is that the 10 fields the import is creating are the ten records that you would like to have in one field. If this is the case, check the "Has Field Names" action argument in the macro. Set it to NO.
What i understand is that the 10 fields the import is creating are the ten records that you would like to have in one field. If this is the case, check the "Has Field Names" action argument in the macro. Set it to NO.
K kholm Registered User. Local time Today, 13:28 Joined Jun 25, 2001 Messages 63 Jul 8, 2002 #6 Query The query idea worked great. I didn't use As Mush and am not sure what that means. Kristin
