Merge Records

[zyus]

My sample field and records are as follow

Code MemberID
ABC 123
ABC 321
CDF 456
GHI 789

How to group the code & memberid in query as i would expect the result as
follow :

Code Member
ABC 123 & 321
CDF 456
GHI 789

Thanks

 

[Douglas J. Steele]

You'll need to use VBA code such as what's shown in
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web"