Changing field data into labels on the y-axis

[slaterino]

Hi,
I am hoping to create a datasheet that uses data from a field as its y-axis. At the moment my datasheet looks like this:

First Name | Last Name
John | Smith
Wendy | McDonald

But I am hoping to change it into this:

First Name | Last Name | Session 1 | Session 2 | Session 3 | etc.
John | Smith | Yes | No | Yes
Wendy | McDonald | Yes | Yes | Yes

This information would be taken from a query with a structure like this:

URN - unique ID
FirstName
LastName
SessionID
CourseID
SessionDate
Current - yes/no

Now the datasheet will be controlled by the CourseID so that it will only show records with that CourseID. Each CourseID will have a number of SessionID's, and each one will have a different date. It's these SessionID's which would make up the column headings after First Name and Last Name. The Current field is the field shown in the example above which will either be Yes or No.

I have seen that I can do something similar to this using PivotTable but it's not possible to edit the Current field if I was to do that. Does anyone know how else I could design this datasheet? Any help whatsoever would be ENORMOUSLY appreciated.



Thanks,
Russ

[ajetrumpet]

Russ,

where did the requirement come from? You have data that certainly be worked with, but what you've established as your goal here really rubs against the grain of the database object.

And why a pTable? Would a pChart satisfy the needs as well? Note that a pChart creates crosstab format data automatically, so it would not be difficult to make a chart (or a table for that matter) with First/Last Name as a data series (say, in a legend) as the sessions on the y-axis...

(do not cross post: http://www.access-programmers.co.uk/...d.php?t=199519)