Has Anyone Attempted a Report for a Class Attendance Log?

[zmbd]

Attached is a screen shot of an Excel spreadsheet I use for classroom attendance that I print out each year. I'd love to be able to do this using just Access. Has anyone attempted something like this in the past? I've created a few complex sample submission forms; however, this one is a bit more than I've attempted.

z

[PhilOfWalton]

Is this a report with variable number of columns based on a Crosstab Query?

Phil

[jforbes]

The only thing that stands out as complex that I see is the Header. Getting the Lines to line up and look pretty can be a pain in the butt, but I don't think that would stop you. Especially not you. =)

You could write a routine to loop through and populate the Headers from a separate Table and then the Student Names would populate in the traditional way.

Maybe...

• Create a Table, name it ReportHeaders or something
• It would have the columns ReportName, Index, Header.
• You could set a TempVariable for the ReportName before calling the Report.
• In the Header of the Report, use the ReportName TempVar to query and get a list of Headers and order them by the Index. Then iterate through them and apply them to the Labels for your Headers.

[zmbd]

Ok, mangaged to ckludge this togeither

1) Acc2013 has the layout grid. Wow is there very little information about this feature. Discoved that one has to insert a control on the report first and then you can get at the grid layout controls>
Ribbon>Report Design Tools>Arrange>Table (etc...)
Here one can then start inserting, spilitig, merging, etc...
Cell styles are under the R>Table>Gridlines group control
You can also select an empty cell and use the properties FORMAT tab.
For a cell with a control, the properties FORMAT tab has the "Gridline Style..." properties that can be set.
>> EMPTY CELLS do not show up in the properties control selection combobox until they are selected by the mouse on the report/form

2) Text rotation is only in the Book-Title orientation. For English words this means that the bottom of the letters are to your left as one would see on a textbook.

3) I used two sub-reports to make this more dynamic. The first report is for the month section, the second is for the class dates. This was the only way I could figure out how to get the months and days to follow. The grid layout is sized to sync between to the two

4) The main report is tied to the student table
The columns under the dates are layout gridlines sized to match the date sub-report.

Very fiddly to do this way.
There may be a point in time where I tie the attendance to the individual cells in the detail section so that this looks like a cross-tab style query; however, I have a cross-tab query and report already :)

A little bonus, I have an extra column that I didn't plan on; however, I'm sure that it can be used for some little comment/notation.

There's only one issue at this point and it's more aesthetic than needed, the old roster used an entire page, 30 Rows.... a new thread covering that little monkey:
Appending Consistent Number of Blank Rows to Report

[ADezii]

I agree with jforbes in that the most complicated aspect of this is generating the Headers for a variable number of Months and their associated Dates. I threw together a Demo that will do this for Months based on a partial Report Template. Days should easily be able to be incorporated into the Logic by adding them to the Months Table. Adding the Dates to the Report can be done at the same time that the Month Controls are created. Hope this helps in some small way.

P.S. - To center the Text Vertically for each Month as the Month Controls are created, set the RightMargin Property = 620 (approx.) for each Control within the Loop:

With ctl
  'set Label Properties here
End With