Tracking Daily Attendance in MS Access

[SKBodner]

Hello,

I'm stumped and I'm hoping someone could help me figure out the best
way to track daily attendance for the next 6-4 months.

I have a list of 80 or so participants who should be attended training
on a daily basis and am tracking if they attended, have an unexcused
absence, or are absence with an excuse. At the end of the month, I plan
to print out reports on those who have missed more than one day with an
unexcused absence. My query will show the number of days missed over
the number of days training has been provided to give me a percentage
of days missed.

I understand that over the next 6-9 months, there are a number of days!
Should I just create a sheet with the participants ID and Name and
start the next column heading as May 1, then May 2...all the way to end
of the training program? Should I have one table for May, another for
June, or put all the dates in one table? Is there a better way to do
this?

Any suggestions would be appreciated.

Sandy :o)

[Bob Quintal]

"PC Datasheet" <No****@Spam.Co m> wrote in
news:lp******** ******@newsread 2.news.pas.eart hlink.net:

A couple of notes for using Bob's suggestion ----
1. Don't name your date field in the Attendance table "Date".
"Date" is an Access reserved word and must not be used as a
field name. Sooner or later you will experience a problem if
you do.
A scare tactic? the "will experience" is incorrect, "might
experience" is the truth. But thanks for pointing out the
possibility.

2. Do not set up your attendance form where you have to enter the date for each record. Create a routine to create
the dates you need for any class month and then incorporate
the routine in a query to automatically generate the dates.
I said:
every schoolday, you run an append query which adds a record for
each student, the current date, optionally a default status.
Then the teacher changes status as required.

Steve, if you had spent 15 seconds thinking about the
implications of what I wrote, you would see the total redundance
of your reply.
3. If you don't have too many different types of Status, use
an option group bound to Status on your form. This will give
you multiple checkboxes where you can check the appropriate
Status for each student.

checkboxes? maybe radio boxes, maybe a combobox, but never
checkboxes for something like this.

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting
help
re******@pcdata sheet.com

And over 2286 of those have come to the newsgroups afterwards
seeking help to fix your "solutions" .

--
Bob Quintal

PA is y I've altered my email address.

[Keith Wilby]

"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** *************@2 07.35.177.135.. .

Steve, if you had spent 15 seconds thinking about the
implications of what I wrote, you would see the total redundance
of your reply.

Bob, my apologies, I actually didn't read your post before I read PCD's.
Valuable lesson learned. :-)

Keith.