v.97 - Concatenating 4 fields, either of type text or memo? 1

[razarsharp]

I would like to combine 4 fields into a single field using a make table or append query. But any 3 of the 4 fields have to be a memo attribute because they exceed 255 characters. When I go [Field1] & [Field2] & etc. and then try to view the datasheet it gives me "Can't combine memo or OLE object when selecting unique values" or something similar. And if it does let me perform this operation it cuts off after the 255th charact which happens to be only a single field and some of the second in line; whereas I need all 4 complete fields combined. Please advise. Any help is welcomed and muchly appreciated. Thank you for you time and efforts!

 

[scking]

Sounds like you are trying to concatenate them into a field defined as a primary key. This would then be a database design issue. I have never heard of a memo field being used as a primary key. There must be some other field or identifier which could be used as the primary key. This could also be the property of the field which is identified as unique. I'm guessing here because your description only alluded to what I would consider the problem area.

Steve King