MS-Access透视列 [英] MS-Access pivot columns

问题描述

我创建一个MS Access 2007查询，其中同一客户有多个项目和数据显示如下：

I create an MS Access 2007 query where the same customer has multiple project and data appear like:

1 | Foo

1 |栏

1 | Baz

2 |对于

3 | Cad

3 |凸轮

1 | Foo
1 | Bar
1 | Baz
2 | For
3 | Cad
3 | Cam

，我想将其转换为

Foo | Bar | Baz

2 |对于|

3 | Cad | Cam |

1 | Foo | Bar | Baz
2 | For |
3 | Cad | Cam |

目标是为每个客户创建一个电子表格视图（1,2,3），可以从单词中读取，以便为每个客户创建邮件

The goal is to create a spreadsheet view per customer (1,2,3) which can be read from word in order to create mailings per client

推荐答案

有一个非常信息数据库杂志文章，然而，它声明在查询中没有办法这样，所以它必须在VBA中完成。

There is a very informative Database Journal article that does something similar to what you want; however, it states that there is no way to this in a query, and so it must be done in VBA.

这篇关于MS-Access透视列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！