Tables - grouping of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Trish said:
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
Click to expand...
 
Trish said:
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
Click to expand...
 
Trish said:
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
Click to expand...
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get last 6 rows in list where 1 cell matches certain criteria 2
Change results to display across rather than in a list 1
Separate Names 3
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
counting repeats. 8
name extraction 6
Using one form to create mulitple records 1
Creating Multiple Records from Single Delimited Field 1

Back
Top