Rows to columns;
I have a table with three fields
ID,Desc,Code
1,aaa,code1
2,bbb,code2
3. aaa,code3
4, bbb,code4
I need a query creating these two columns:
Desc,Code
aaa,code1;code3
bbb,code2;code4
how can I do this?
Novice
Windows 7 64bit 
Access 2010 32bit
Rows to columns;
I have a table with three fields
ID,Desc,Code
1,aaa,code1
2,bbb,code2
3. aaa,code3
4, bbb,code4
I need a query creating these two columns:
Desc,Code
aaa,code1;code3
bbb,code2;code4
how can I do this?
VIP
Windows XP Access 2010 32bit
Common topic. Search forum or Google (crosstab, horizontal, left to right). Here is one
https://www.accessforums.net/forms/d...lly-20989.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Table rows to columns
Posting Permissions
Reply With Quote