Prev: Wizard crash because VBA stopped it working
Next: Student table
From: zyus on 14 Apr 2010 05:28
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

From: Douglas J. Steele on 14 Apr 2010 07:19
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"

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"zyus" <zyus(a)discussions.microsoft.com> wrote in message
news:53810901-49B9-4F6B-A37A-4606EE4DE464(a)microsoft.com...
> 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
>


 | 
Pages: 1
Prev: Wizard crash because VBA stopped it working
Next: Student table