Records in a row (1 Viewer)

[aprentice]

Is there a (easy) way to present records in a single row?
Like continuous forms, but in this case to be sth like continuous columns
For example I want sth like this

Student1 LessonA LessonB LessonC
Student2 LessonX LessonB LessonZ

and so on.
The records are in a table the structure of which is
Student
LessonI
LessonII
LessonIII
LessonIV
....
additional fields

where e.g. for Student2, LessonI=LessonX, LessonII=LessonB and so on

Any ideas?
Thnx in advance

 

[statsman]

Just set up your report the way you have it listed in your question.

 

[aprentice]

Just set up your report the way you have it listed in your question.

Thnx abt the reply but I have to apologize for making
a serious mistake

The Lessons are in a different table, connected with Students with a one-to-many relations (1stud many lessons).

So setting up like the way u suggest is impossible.

Any ideas now?

 

[WayneRyan]

Apprentice,

http://www.access-programmers.co.uk/forums/showthread.php?t=70399

Wayne

 

[aprentice]

Thnx it worked!