noramosquito
New Member
I have searched 'concatenate' topics and have been unable to find the answer I need. This posting came close access sql query to concatenate rows but my attempts to make it work for my purpose failed.What I have is a table like this\[code\]Lic# | Permit | Year ------------------------1 | NS1 | 2003 1 | NS1 | 2004 1 | NS2 | 2004 2 | TR | 2012 2 | NS2 | 2012 3 | OR | 2008 2 | OR | 2011 2 | NS1 | 2011 2 | TR | 2011 \[/code\]....And so forth. This table has many unique license numbers with permit type and year (from 2003-2012) listed for each.What I would like is to create a table that would display the information like this\[code\]Lic# | Permit | Year -----------------------------1 |NS1 | 2003 1 | NS1, NS2 | 2004 2 | TR, NS2 | 2012 3 | OR | 2008 2 | OR, NS1, TR | 2011\[/code\]