I'm trying to use FMP to track class/student attendance. I've got my classes and students setup and what I'd like to do is be able to enter in who attendend what class and then run a report saying average attendance is...I'd also like to run a simiilar report sayind "john smith attendended an average of ..." make sense? Anyone know how to do this? I'm trying to use a check box for a simple check meaning "yes" and unchecked for "no" on attendance. Thanks for all the help!

'm not sure where to even post this...I'm looking for some type of templete to track student attence and then run reports based on class and students. Any ideas? Thanks.

I couldn't merge your topics, so I'm quoting the one that I deleted as being a Duplicate Post.

There have been discussions about this topic in the past, and I believe there are a couple of sample or help files posted.

Do a search of the Forum using [color:blue]+Attendence +Record or [color:blue] +Absence +Record as keywords, and you should get a few hits.

To access the Search, click on the Search [color:blue]Button in the Menu Bar, and then Click on the [color:blue]Advance Search. There is a [color:red]? located by Mode that gives you some helpful information on do in Searches.

HTH

Lee

If you want a checkbox for "yes" or "no", that implies a record for every student, for every one of their classes, for every day. So it becomes a matter of writing a script to create all those records at the appropriate time.

And probably a script and button for the teacher to say "yes to all" for a day (then uncheck absent students). Unless you want them to check off each.

Then your reports are fairly straightforward, though there are a lot of records. It's a matter of Summary fields and Subsummary parts

An alternative method is to assume all students attend all their classes, and only create records for absentees. Far fewer records. But a bit more work to do reports. Personally I'd go for the 1st method, with archiving of older records, to keep the size down. But others may prefer the latter method, with fewer records. In reality I've not done a school solution myself, so my opinion is just my opinion.