MS-Access Control Point Columns
I am creating an MS Access 2007 query where the same client has multiple projects and data:
1 | Foo
1 | Bar
1 | Base
2 | For
3 | Cad
3 | Cam
and I want to convert it to something like
1 | Foo | Bar | Base
2 | For | 3 | Cad | Cam |
The goal is to create a spreadsheet view for each customer (1,2,3) that can be read from a word to create campaigns to the customer
0
stefanos
source
to share
1 answer
There is a very informative Database Journal article that does something similar to what you want; however, it says there is no way in the query, so it must be done in VBA.
+1
source to share