Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Database > How to merg fields in MS Access

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

How to merg fields in MS Access

Reply to Message Icon

Name: vahidam
Date: February 16, 2009 at 22:39:39 Pacific
OS: Windows XP
Subcategory: General
Comment:

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



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links
Ads by Google


Results for: How to merg fields in MS Access
How to edit query in MS Access using batch www.computing.net/answers/dbase/how-to-edit-query-in-ms-access-using-batch/682.html

calculation in ms access www.computing.net/answers/dbase/calculation-in-ms-access/657.html

How to create a function in MS Acce www.computing.net/answers/dbase/how-to-create-a-function-in-ms-acce/328.html