combine records

[Guest]

Can i combine/append the contents of a memo fields record to another memo
field in another table?

Table 1
Record Memo field Part No
1 abc 1111
2 efg 1111
3 xyz 1111

Table 2
Record Memo field Part No
1 abc; efg; xyz 1111

 

[Douglas J. Steele]

That's really not a recommended thing to do: it makes look ups much harder
(for instance).

Why not simply have a query that returns that data? Check
http://www.mvps.org/access/modules/mdl0008.htm or
http://www.mvps.org/access/modules/mdl0004.htm at "The Access Web" for
suggestions.

 

[Guest]

I'm trying to consolidate comments noted in a memo field. I have a query and
macro that groups unique parts and wanted to have a memo field that
consolidates all the comments from another table/field into one record.
Is there another way?

 

[Douglas J. Steele]

Unless there's a legitimate reason to consolidate them, you're really better
off not doing it. However, the links I gave you will show you how to
consolidate them. You'd need to write a query that uses the function and use
that to populate the new table.

 

[Guest]

Thanks, I'll look at the links.

Unless there's a legitimate reason to consolidate them, you're really better
off not doing it. However, the links I gave you will show you how to
consolidate them. You'd need to write a query that uses the function and use
that to populate the new table.