Birthday List

J

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
 
F

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top