Attendance Sheet in Access

[dennishancy]

I am envisioning a form in Access that allows you to enter attendance
data. Here is an example of what I am hoping to achieve:

11/1 | 11/2 | 11/3 |
--------------------------------------------------------
Randy | x | x | x |
--------------------------------------------------------
Amy | x | x | |
--------------------------------------------------------
Duane | | | x |
--------------------------------------------------------


I'd like the users to see that format when they enter attendence data.

Any sugggestions as to how to set up the tables? or how to create a
form that looks like this?

I am thinking I want a separate table to hold the meeting dates. But
somehow those meeting dates need to be column headings on the form.

Thanks.


Dennis Hancy
Cleveland, OH

 

[Lynn Trapp]

Dennis,
What you are describing is the way you might do things in Excel but not in
Access. What you want would make a data value (the date) to be the field
name and it is never good to store data in a field name. If you set up a
table with Attendee, AttendanceDate, and Attended fields you can then use a
crosstab form to display the data in a report in the format you want, but it
would not be possible to use a crosstab to do the data entry.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Fred Boer]

Dear Dennis:

Lynn is an expert and can help you with Access, but have you seen these
attendance templates that are available from Microsoft? It might serve as a
basis to a solution that wouldn't involve Access:

http://office.microsoft.com/en-us/templates/TC011887561033.aspx
http://office.microsoft.com/en-us/templates/TC012291251033.aspx
http://office.microsoft.com/en-us/templates/TC061893751033.aspx

HTH
Fred Boer

 

[Sprinks]

Lynn,

You've always been so clear in your assistance to me in the past, I hope
you'll respond to my related post "Timesheet Application" in the Forms
newsgroup.

I am porting an Access application from Excel to simplify reporting and
invoicing, but the current crosstabbed worksheet is very convenient to work
from as it eliminates entering the date and project fields for each record.

But although I can't use a crosstab for the data entry, perhaps I might
construct a form for the data entry Bound to a dummy table, allow the user to
confirm his entries at the end of the period, perform an Insert query to post
the data to normalized tables, clear the dummy table, and create a new dummy
record for the next period. A crosstab query could then present historical
data for viewing.

I'd appreciate your comments on this approach and/or any other suggestions
on making this work.

Sprinks