Design question for attendance sheet

[MikeB]

I may have to keep an attendance register for the kids attending my
chess club.

I was thinking that since I have a record of whether they played a
game on a particular day, that serves as a record of attendance.
Alternatively I can create a joined table of MeetingDate and PlayerID
to represent that a player was present.

What I'm having difficulty with is to print the report in a way that
the names are in a column on the left and then there is a column for
each club date with a "P" or an "A" to indicate that they were
present.

I can't figure this out. I'm not even sure I'm explaining it well. As
I'm typing, I'm thinking that this might be a crosstab-type of
application? Am I thinking along the right lines?

 

[hfreitas]

I may have to keep an attendance register for the kids attending my
chess club.

I was thinking that since I have a record of whether they played a
game on a particular day, that serves as a record of attendance.
Alternatively I can create a joined table of MeetingDate and PlayerID
to represent that a player was present.

What I'm having difficulty with is to print the report in a way that
the names are in a column on the left and then there is a column for
each club date with a "P" or an "A" to indicate that they were
present.

I can't figure this out. I'm not even sure I'm explaining it well. As
I'm typing, I'm thinking that this might be a crosstab-type of
application? Am I thinking along the right lines?

 

[Sninkle]

In your MeetingDate table, do you have an attendance field that currently
stores the A or P value or is it just a case of if there is a date they
attended, and no date means no attendance?

 

[MikeB]

In your MeetingDate table, do you have an attendance field that currently
stores the A or P value or is it just a case of if there is a date they
attended, and no date means no attendance?

I haven't got anything as yet, I'm trying to figure out what I have to
get and how to do it. They "typical" view of this I have is
spreadsheet like, with a column for the names and a column for each
date. However, that isn't correct for a database.

I also need to figure out how to map the data into a typical view to
create an attendance list.

Since I haven't kept attendance online (I have a roster with
checkmarks), I can either use the games data or try and find all the
different rosters and enter the data from there once I've figured out
what data I need to enter.

What I do have are a table of Matches (one for each meeting date) and
a table of Games (with FK to the Match and with the ID of the players
who played in the game).

 

[Duane Hookom]

I would use a main report with each kid as a record source. Then use a
multicolumn subreport in the Page or Report header with each unique date. For
each students attendance, I would create a similar subreport with each date
and an A or P.

 

[MikeB]

I would use a main report with each kid as a record source. Then use a
multicolumn subreport in the Page or Report header with each unique date. For
each students attendance, I would create a similar subreport with each date
and an A or P.

Multi-column subreport. Sounds like what I'm needing. I'm looking into
it. Thanks.