Group Concat in msaccess

[beulajo]

I have two tables say (diocese and district)

one district can have more than one diocese

so my table structure is like this
DistrictID(Auto number) District(Text) and Diocese(Text as comma separator)
sample data DistrictId (1) District(Vellor e) diocese(1,2,3)( Ids of the diocese table)

when I list district I need to show District and Diocese. But the diocese are saved as ids with comma separator. I need to show them the related diocesed as a text
like this (vellore,Dharma puri,Thirupattu r)

The table is in msaccess

how do i write query and achieve this. Is Manual generation the only way to achieve this result???

thanks in advance

[tlhintoq]

Until someone with more experience can offer more targeted advice I can point you toward these:

Database tutorial Part 1
Database tutorial Part 2