How to merge fields in table?

[medim84]

Hello everyone,

I have table with 4 different fields, data type – memo, with more then 80 records with a lot of text. Now I need only 1 field to store all data from that 4 fields in same table, and then to delete them, is it possible to do that?

Thanks in advance

[JConsulting]

Hello everyone,

I have table with 4 different fields, data type – memo, with more then 80 records with a lot of text. Now I need only 1 field to store all data from that 4 fields in same table, and then to delete them, is it possible to do that?

Thanks in advance

Is this a one time deal? If so, I would recommend copying and pasting into Excel, concatenating the fields there then pasting back into access into a new field.

the reason for this is:

Normally you can concatenate fields in an update query, but with memo fields, it's always iffy as to whether you get all the data. I read somewhere it's a size limitation of x number of bytes per control...but since you only have 80 records, and I'm assuming this is a one shot deal..you'd save a lot of time and effort on this one by just cutting and pasting.

J