Tables - grouping of data

[Trish]

Is there a way I can group data in records. Eg

Instead of:

Name Colour
Jones Blue
Smith Black
Jones White
Smith Green

Thanks
can I have:

Name Colour
Jones Blue, White
Smith Black, Green

 

[Allen Browne]

You would not want to store the data that way in your tables, but it is
possible to output it that way on a report.

It's a bit messy, but this link should give it to you:
http://www.mvps.org/access/modules/mdl0004.htm

 

[adsl]

Is there a way I can group data in records. Eg

Instead of:

Name Colour
Jones Blue
Smith Black
Jones White
Smith Green

Thanks
can I have:

Name Colour
Jones Blue, White
Smith Black, Green

 

[adsl]

You would not want to store the data that way in your tables, but it is
possible to output it that way on a report.

It's a bit messy, but this link should give it to you:
http://www.mvps.org/access/modules/mdl0004.htm

 

[adsl]

Is there a way I can group data in records. Eg

Instead of:

Name Colour
Jones Blue
Smith Black
Jones White
Smith Green

Thanks
can I have:

Name Colour
Jones Blue, White
Smith Black, Green

 

[adsl]

You would not want to store the data that way in your tables, but it is
possible to output it that way on a report.

It's a bit messy, but this link should give it to you:
http://www.mvps.org/access/modules/mdl0004.htm

 

[adsl]

 

[adsl]

 

[adsl]

 

[adsl]

 

[adsl]

 

[adsl]

 

[adsl]

 

[adsl]

 

[adsl]

You would not want to store the data that way in your tables, but it is
possible to output it that way on a report.

It's a bit messy, but this link should give it to you:
http://www.mvps.org/access/modules/mdl0004.htm

 

[adsl]

Is there a way I can group data in records. Eg

Instead of:

Name Colour
Jones Blue
Smith Black
Jones White
Smith Green

Thanks
can I have:

Name Colour
Jones Blue, White
Smith Black, Green

 

[SteveLoS]

Allen, I have been working with your suggestion but getting an error message
"Undefined Function 'fConcatChild' in expression"
I'm not an advanced user but folowed the string you provided, substituting
of course my own tables, fields, etc.

Any suggestions?