Novice
Windows 7 64bit 
Access 2010 32bit
I have a table with following fields
ID,Desc, Cound, Code
1, AAA,2,Code1
2, BBB, 5,Code1
3, AAA, 3,Code2
4, CCC, 4, Code3
I need this be represent the data as:
Desc, Code1, Code2, Code 3
AAA, 2, 3, 0
BBB, 5, 0, 0
CCC, 0,0,4
How can I do this in a query.
VIP
Windows XP Access 2010 32bit
How many different Code values are there - can a crosstab query work? If not, review:
http://forums.aspfree.com/microsoft-...ry-322123.html
http://allenbrowne.com/func-concat.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.
Query : Matching 2 Fields from Table 1 to 2 fields from Table 2
Table fields which depend on other fields
Posting Permissions
Reply With Quote