I've got a question about SQL query in MS Access, for example I have the following data:
Table1:
NAME ____ CITY ____ FAV
vahid ______ NY _______ A
vahid ______ NY _______ B
hamed _____ LA _______ A
hamed _____ LA _______ C
Do I able to merge them like this in MS Access 2003:
NAME ____ CITY ____ FAV
vahid ______ NY _____ A, B
hamed _____ LA _____ A, C
can anyone give any solution to it ? thanks
Table1:
NAME ____ CITY ____ FAV
vahid ______ NY _______ A
vahid ______ NY _______ B
hamed _____ LA _______ A
hamed _____ LA _______ C
Do I able to merge them like this in MS Access 2003:
NAME ____ CITY ____ FAV
vahid ______ NY _____ A, B
hamed _____ LA _____ A, C
can anyone give any solution to it ? thanks