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.
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.
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.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
resource@pcdatasheet.com
"Bob Quintal" <rquintal@sympatico.ca> wrote in message
news:Xns97BEC4FEDBEB5BQuintal@207.35.177.135...[color=blue]
> "SKBodner@gmail.com" <SKBodner@gmail.com> wrote in
> news:1147215608.544538.193140@y43g2000cwc.googlegr oups.com:
>[color=green]
>> 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)
>>[/color]
> The textbook example would have three tables,
> One for students
> StudentID
> FullName
> Phone,
> etc.
>
> The next is Status,
> 1=present,
> 2=Absent(Excuse),
> 3=Absent(no Excuse)
> 4=Late
> etc.
>
> The last is Attendance which contains
> StudentID
> Date
> Status
>
> 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.
>
>
> --
> Bob Quintal
>
> PA is y I've altered my email address.[/color]
