Concatenating multiple fields from multiple records

[DarkReign]

Could someone point me in the direction of where I can learn to concatenate multiple fields from multiple records into one unbound textbox in a continuous form for display purposes only? I'm creating a database to track multiple medications given to a patient each visit, and multiple parameters for each patient. I've googled for hours but all the examples I've seen are for single fields across multiple records.

For example, for each visit, a patient gets multiple medications, and for each medication we track dose, units, intensity, payer, etc. So it would look something like:

Visit Date | Patient | Age | Sex | about 20 other parameters | Medication 1, dose units, intensity, payer

Visit Date

Patient

Age

Sex

About 20 other Parameters in 20 columns

Medication 1, dose units, intensity, payer Medication 2, dose units, intensity, payer Medication 3, dose units, intensity, payer Medication 4, dose units, intensity, payer Medication 5, dose units, intensity, payer

Would appreciate any help, as I'm all googled out! Thanks!
- Karim

[June7]

Review: http://allenbrowne.com/func-concat.html

You can do a query that first concatenates the fields into a single string then use that query as the source for the ConcatRelated function.

Be aware, the function can really slow down performance of form. Subforms or listboxes would probably be easier and execute faster.