在Access中将记录（ROWS）组合在一起 [英] Combine Records(ROWS) together in Access
问题描述
您好，
我在excel之外的高级数据库方面相当新。
我正在尝试将记录合并到我将使用的数据库中没有，我发现的CONCAT查询或脚本似乎工作得很好。
我需要的是结合这样的记录：
ID机器
AAG99999 CANON 225
ADL900221 OLIVETTI F231
ADL900221 OLIVETTI F232
进入：
ID机器：
AAG99999 CANON 225
ADL900221 OLIVETTI F231，OLIVETTI F232
我知道它看起来很简单，但我还没弄明白怎么做？
有人可以帮忙吗？
Hello,
I am fairly new at doing advanced databases outside of excel.
I am trying to combine records in a database I will be using, none of the, CONCAT Queries or scripts I have found seem to work quite right.
What I need is something to combine records like this:
ID Machine
AAG99999 CANON 225
ADL900221 OLIVETTI F231
ADL900221 OLIVETTI F232
Into this:
ID Machine:
AAG99999 CANON 225
ADL900221 OLIVETTI F231, OLIVETTI F232
I know it seems like it would be pretty simple, but I have yet to figure out how to do it?
Can Anyone Help?
推荐答案
我想提一下，我已经尝试了其他地方给出的一些例子。迭代和其他人。我正在使用access 2000.
I meant to mention that I have already tried a few of the examples given elsewhere on this site and others. I am using access 2000.
您好，
我在使用excel之外的高级数据库时相当新。 />
我正在尝试将记录组合在一个我将要使用的数据库中，没有一个，我发现的CONCAT查询或脚本似乎工作得很好。
我需要的是结合这样的记录：
ID机器
AAG99999 CANON 225
ADL900221 OLIVETTI F231
ADL900221 OLIVETTI F232
进入：
ID机器：
AAG99999 CANON 225
ADL900221 OLIVETTI F231，OLIVETTI F232
我知道它看起来很简单，但我还没弄明白怎么做？
有人可以帮忙吗？
Hello,
I am fairly new at doing advanced databases outside of excel.
I am trying to combine records in a database I will be using, none of the, CONCAT Queries or scripts I have found seem to work quite right.
What I need is something to combine records like this:
ID Machine
AAG99999 CANON 225
ADL900221 OLIVETTI F231
ADL900221 OLIVETTI F232
Into this:
ID Machine:
AAG99999 CANON 225
ADL900221 OLIVETTI F231, OLIVETTI F232
I know it seems like it would be pretty simple, but I have yet to figure out how to do it?
Can Anyone Help?
你好，
我在外面做高级数据库时相当新excel。
我正在尝试将记录合并到我将要使用的数据库中，没有一个，我发现的CONCAT查询或脚本似乎工作得很好。
我需要的是结合这样的记录：
ID机器
AAG99999 CANON 225
ADL900221 OLIVETTI F231
ADL900221 OLIVETTI F232
进入：
ID机器：
AAG99999 CANON 225
ADL900221 OLIVETTI F231，F232 OLIVETTI
我知道这好像这将是非常简单的，但我还没有图怎么做？
有人可以帮忙吗？
Hello,
I am fairly new at doing advanced databases outside of excel.
I am trying to combine records in a database I will be using, none of the, CONCAT Queries or scripts I have found seem to work quite right.
What I need is something to combine records like this:
ID Machine
AAG99999 CANON 225
ADL900221 OLIVETTI F231
ADL900221 OLIVETTI F232
Into this:
ID Machine:
AAG99999 CANON 225
ADL900221 OLIVETTI F231, OLIVETTI F232
I know it seems like it would be pretty simple, but I have yet to figure out how to do it?
Can Anyone Help?
您好Ryan
数据库不是以这种方式工作的。第一个例子是存储这些信息的正确方法。
出于什么目的，您需要以相反的方式取代数据。
Mary
Hi Ryan
databases are not designed to work this way. The first example is the correct way of storing this information.
For what purpose do you need the data displaid the other way.
Mary
你会从我在这些帖子中的一些帖子中看到我非常喜欢玛丽。
然而，如果你绝对的话确实需要这样做，有几个线程可以解决这个问题。
（将一个字段的多行组合成一个结果）& （合并行 - 相反的行）。
You''ll see from some of my posts in these threads that I''m very much with Mary on that point.
However, if you absolutely do need to do it, there are a couple of threads which deal with this issue.
(Combining Multiple Rows of one Field into One Result) & (Combining Rows-Opposite of Union ).
这篇关于在Access中将记录（ROWS）组合在一起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
