query

[Frank Dulk]

I have a query with the following fields:

Patient Quant Remédio
João 1 Analgesic
João 3 Antibiotic
João 1 Vitamin
Maria 1 Analgesic
Maria 1 Vitamin
etc...

I need the following result
João 5 Analgesic, Antibiotic, Vitamin
Maria 2 Analgesic, Vitamin

Somebody can me to help (SQL if possible)

 

[Frank Dulk]

Thank you

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.