将多个字段连接成一个 [英] Concatenating mulitiple fields into one

问题描述

我有1个表，有2个字段，帐户和评论 - 没有主键，因为帐户可以多次相同

帐户评论

12345干得好！ br />
12345坚持下去！

12345满意保证！


我的困境？ 3条评论可以连接成一个字段吗？我尝试创建另一个表，附加帐户（按分组）并添加comments1，comments2等字段。然后，我尝试通过两个记录集来更新第二个表和注释（即注释的第一行注释1，注释2的第二行等等）但我无法通过第一个注释。我创建第二个表的目的是插入所有注释行然后将它们连接起来。


任何指导都表示赞赏。

解决方案

您已在访问文章部分而不是访问论坛部分发布了您的问题。

我已经为您移动了它。


请记住为任何已启动的线程提供有意义的标题（请为线程使用适当的标题）。这有助于确保其他成员以及公众更有机会找到任何类似问题的答案。


主持人。

< blockquote>

我有1个包含2个字段的表，帐户和评论 - 没有主键，因为帐户可以多次相同

帐户评论

12345干得好！

12345坚持下去！

12345满意保证！


我的困境？ 3条评论可以连接成一个字段吗？我尝试创建另一个表，附加帐户（按分组）并添加comments1，comments2等字段。然后，我尝试通过两个记录集来更新第二个表和注释（即注释的第一行注释1，注释2的第二行等等）但我无法通过第一个注释。我创建第二个表的目的是插入所有注释行然后连接它们。


任何指导都表示赞赏。

将此函数粘贴到模块中并保存

展开 | 选择 | Wrap | 行号

我有1个表，包含2个字段，帐户和评论 - 没有主键，因为帐户可以多次相同

账户评论

12345干得好！

12345坚持下去！

12345满意保证！


我的困境？ 3条评论可以连接成一个字段吗？我尝试创建另一个表，附加帐户（按分组）并添加comments1，comments2等字段。然后，我尝试通过两个记录集来更新第二个表和注释（即注释的第一行注释1，注释2的第二行等等）但我无法通过第一个注释。我创建第二个表的目的是插入所有注释行然后连接它们。


任何指导都表示赞赏。

我在帖子Can can be Done中回答了这个问题。 ......这似乎是双重发布？


Jim

I have 1 table with 2 fields, Account and Comments-no primary key as the account can be the same multiple times
Account Comment
12345 Good Work!
12345 Keep it Up!
12345 Satisfaction Guaranteed!

My dilemma? Can the 3 comments be concatenated into one field? I tried creating another table, appending the accounts (grouped by) and added comments1, comments2, etc. fields. I then tried to run through both recordsets to update the second table with the comments (i.e, 1st line of comments into comments1, 2nd line into comments2 and so forth) but I couldn''t get past the 1st comment. My goal for creating the second table was to insert all lines of comments and then concatenate them.

Any guidance is appreciated.

解决方案

You have posted your question in the Access Articles section rather than the Access Forum section.
I have moved it across for you.

Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for Threads ). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR.

I have 1 table with 2 fields, Account and Comments-no primary key as the account can be the same multiple times
Account Comment
12345 Good Work!
12345 Keep it Up!
12345 Satisfaction Guaranteed!

My dilemma? Can the 3 comments be concatenated into one field? I tried creating another table, appending the accounts (grouped by) and added comments1, comments2, etc. fields. I then tried to run through both recordsets to update the second table with the comments (i.e, 1st line of comments into comments1, 2nd line into comments2 and so forth) but I couldn''t get past the 1st comment. My goal for creating the second table was to insert all lines of comments and then concatenate them.

Any guidance is appreciated.

Paste this function into a module and save it

Expand|Select|Wrap|Line Numbers

I have 1 table with 2 fields, Account and Comments-no primary key as the account can be the same multiple times
Account Comment
12345 Good Work!
12345 Keep it Up!
12345 Satisfaction Guaranteed!

My dilemma? Can the 3 comments be concatenated into one field? I tried creating another table, appending the accounts (grouped by) and added comments1, comments2, etc. fields. I then tried to run through both recordsets to update the second table with the comments (i.e, 1st line of comments into comments1, 2nd line into comments2 and so forth) but I couldn''t get past the 1st comment. My goal for creating the second table was to insert all lines of comments and then concatenate them.

Any guidance is appreciated.

I have answered this in the thread "Can this be Done" ...this appears to be a double posting??

Jim

这篇关于将多个字段连接成一个的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！