Combining values in the same field

[Sidran]

I've heard of concatenate in MS Access, but this includes combining 2 values from different fields into one field. Is it possible to combine 2 values in the same field if the Name is the same.



For example:
Table 1

Name	Field1
A	AAA
A	BBB
B	CCC
C	DDD

To

Table 2

Name	Field1
A	AAA,BBB
B	CCC
C	DDD

Since the name "A" was the same for AAA and BBB, it got combined into AAA,BBB. I was wondering if this could be done on Access.

[Sidran]

Found out how to do it... but i don't know how to close the post...

[recyan]

In Thread Tools, near top right, select "Mark this thread as solved".

Edit : Would be helpful to others, if you tell how you manged to solve it.

Thanks

[Sidran]

Thanks for your help recyan.

I didn't really solve it. What I wanted to was present the data from Table 1 in the form of Table 2, but Table 2, although called a table, was a report. So I managed to get the result I wanted by using grouping levels to group by the Name field and the data in Field1 appeared below the name in the report.

[recyan]

Thanks for the update.

Thanks