Combine Fields

[annettem]

I have a table that looks like this:

Name Rank Service
Mary Smith 30 Case Mgt
Mary Smith 1 Brain Injury
Mary Smith 15 Autism
John Doe 54 Brain Injury
John Doe 199 Autism
Bob Williams 50 Case Mgt


I want to end up with a query of table of:

Name Rank/Service1 Rank/Service2
Rank/Service3
Mary Smith 30 Case Mgt 1 Brain Injury
15 Autism
John Doe 54 Brain Injury 199 Autism
Bob Williams 50 Case Mgt

Any suggestions?

 

[tina]

take a look at
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'.

hth

 

[OfficeDev18 via AccessMonster.com]

Annette,

What will you do when you have more than 3 records for the same client?

You might be better off with a format like this:

Mary Smith

1 Brain Injury
15 Autism
30 Case Mgt

Total records for Mary Smith: 3 Highest Rank/Service: 1/Brain Injury

Bob Williams