Hi all
As I'm new to all this please stick with me.
I've got to 2 columns in a table one is post code the other is owner. However, post code is duplicated but has a different owner eg
Postcode Owner
CVXX 1CC Coventry
CVXX 1CC Birmingham
CVXX 1CC Warwick
What I'd like to do is concatenate up the owner and put it into a new table of unique postcodes with its owner eg
Postcode Owner
CVXX 1CC Coventry, Warwick, Birmingham
Can this be done through SQL or would it require some sort of VBA macro in Access
I'm working in Access 2007, any help would be appreciated.