By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,136 Members | 1,842 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,136 IT Pros & Developers. It's quick & easy.

How to merge fields in table?

medim84
P: 4
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
Aug 31 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
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
Aug 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.