List items on one line on a report...HELP

[Leaner79]

Hi,
i have a table and i'd like to view the data in that table in a report.
the table has 2 fields, Date & Medication
The table looks something like this
Date Medication
01/02/2002 TDF
01/02/2002 Z5H
01/02/2002 IPP
01/03/2002 LLP
01/03/2002 PHT
01/03/2002 YHJ
01/03/2002 OPM

I would like the report to desplay this data like this
01/02/2002 TDF, Z5H, IPP
01/03/2002 LLP, PHT, YHJ, OPM

 

[Remou]

There is a concatenation function in the FAQs:
How to concatenate multiple child records into a single value
faq701-4233
You will also find several posts on the subject. For reports, you will need to use the On Format event for Deatil, as far as I recall.

 

[CosmoKramer]

Here's another FAQ: faq703-3587

Si hoc legere scis, nimis eruditionis habes

 

[Leaner79]

Thanx,
the FAQ:: FAQ703-3587 worked for me. i can get everything on to one line
But is there a way to group by date?

 

[dhookom]

Create your report based on a summary query that groups by Date. Don't include the Medication field. Then get the medications with the generic concatenate function found in the faq remou suggested.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CosmoKramer]

Sure, grouping is inherently part of the solution I suggested. Just specify the grouping to be done by your date field and include that date control with your text string of meds and you should be all set.....

Si hoc legere scis, nimis eruditionis habes