display one field horizentally

xcao

Registered User.
Local time
Today, 15:45
Joined
Nov 25, 2003
Messages
40
Hello, I would create a report for students demographic information.

The report will be used as a letter, and send to parents.

Like:

Dear Parents:

Here are your 3 children info:

Student1 name, student2 name, student3 name.

But in my query, I have one field called studentname,then I group by parents. So in the report, the students name is in detail section, and it will list as

student1 name
student2 name
student3 name
Student4 name

How can I display it like this

Student1name student2name
student3name student4name

Note I only have the field name studentName.

Thanks
 

Users who are viewing this thread

Back
Top Bottom