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!