Birthday List

[Jeffrey Cox]

Hi Community,

I have a report that shows a list of birthdays of my students and it's
working fine... except...

In the report header I have the headings for the different columns and in
the Details section I have the actual textboxes that get filled from the
query.

03 Jeff Cox Know How 1 English
03 Jeff Cox Forum French
05 Lisa R Know How 3 English

The problem is that the students may have more than one class; English,
French, Spanish etc. And the list shows the name of a student 3 times if he
has 3 classes. What I want is the report to show the name of the students in
a row and a list of classes in a column at the side of their name, as seen
below:

03 Jeff Cox Know How 1 English
Forum French
05 Lisa R Know How 3 English

Any ideas would be very greatful,

J Cox

 

[fredg]

Hi Community,

I have a report that shows a list of birthdays of my students and it's
working fine... except...

In the report header I have the headings for the different columns and in
the Details section I have the actual textboxes that get filled from the
query.

03 Jeff Cox Know How 1 English
03 Jeff Cox Forum French
05 Lisa R Know How 3 English

The problem is that the students may have more than one class; English,
French, Spanish etc. And the list shows the name of a student 3 times if he
has 3 classes. What I want is the report to show the name of the students in
a row and a list of classes in a column at the side of their name, as seen
below:

03 Jeff Cox Know How 1 English
Forum French
05 Lisa R Know How 3 English

Any ideas would be very greatful,

J Cox

Set the control's HideDupicates property to Yes.