query outout formating

[SF]

I have a project table that links to tblProvince and tblDistrict thru
provinceID and DistrictID respectively. A project can have one or more
districts

When a create a query it show:

ProjectID Project Name Province District
1 AA PP D1
1 AA PP D2

Is it possible to put the query into the following format

ProjectID Project Name Province District
1 AA PP D1, D2,...



SF

 

[John Spencer]

Take a look at Duane Hookom's solution at

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

That will wrap in the newsreader, but you can go to
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
and look around