printing across in a report: a challenge

[John Milbury-Steen]

I have a student roll for a given class. I also have a table of when that
class meets. I want to produce a report that will be an attendance form.
(A simple empty grid) It will look like this:


4/1/04 4/2/04 etc. up to 28 dates

Jim
Frank
Mary
etc.

The teacher will take this report and with a pen or pencil will mark
"absent" or "present" in each cell.

Now in Access it is a piece of cake to produce this:

4/1/04
Jim
Frank
Mary
4/2/04
Jim
Frank
Mary
etc.

or this:

Jim
4/1/04
4/2/04
Frank
4/1/04
4/2/04
etc.

but how do you get the date value to print across rather than down?????

 

[Douglas J. Steele]

Create a Crosstab query and base the report on that.

 

[Roger Carlson]

You can create a CrossTab query. The Crosstab Query Wizard will do one for
you, but it is going to want to put some value in the squares. Go ahead and
let it. After it is done, go to the Design view and change the function in
the Value column to Expression and replace the field name above with "".

The SQL should look something like this:
TRANSFORM "" AS Expr1
SELECT YourTable.StudentName
FROM YourTable
GROUP BY YourTable.StudentName
PIVOT YourTable.ClassDate;