Re: Group part options by part

From: Jason Lepack <jlepack@xxxxxxxxx>
Date: 31 May 2007 10:41:10 -0700

You require this:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%20To%20Concatenate%20Child%20Records'

Cheers,
Jason Lepack

On May 31, 1:32 pm, asc4john <j...@xxxxxxxxxx> wrote:

I have a few tables describing parts and thier options.
tblParts pNumber and tblOptions with pNumber, option
I do a SELECT FROM query with a join and I get

Part Option
123 A
123 B
123 D
234 A
234 D

Can I get the following using SQL or is this something that needs VBA
code or a combination of both.
Part Options
123 A,B,D
234 A,D

Thanks

References:
- Group part options by part
  - From: asc4john

Prev by Date: Group part options by part
Next by Date: trying to do negative number in an input mask
Previous by thread: Group part options by part
Next by thread: trying to do negative number in an input mask
Index(es):
- Date
- Thread

Relevant Pages

Re: Group part options by part
... Jason Lepack ... tblParts pNumber and tblOptions with pNumber, ... I do a SELECT FROM query with a join and I get ...
(comp.databases.ms-access)
Group part options by part
... I have a few tables describing parts and thier options. ... tblParts pNumber and tblOptions with pNumber, ... I do a SELECT FROM query with a join and I get ...
(comp.databases.ms-access)