1 2 Previous Next 20 Replies Latest reply on Jul 14, 2011 5:01 AM by mazirrakhan

    Attendance Sheet

    sly_1

      Title

      Attendance Sheet

      Post

      Im now trying to build an attendance sheet,

       

      Its a 12 month calendar to input attended hrs. I would also like to have the hours added up on a weekly basis.

      This will be a portal to the student record via portal. This will also be related to the student id ( serial number).

      I have just had no luck accomplishing this.

       

      any help would be greatly appreciated.

       

      Sly

        • 1. Re: Attendance Sheet
          philmodjunk
            

          Check out the WeekofYear function. Using this in combination with a Sum function should return the value you need.

           

          An expression such as:

           

          WeekofYear(datefield) & " " & Year(datefield)

           

          in both tables would allow you to use them in a relationship to link the two tables by week of year. (You can use two pairs of fields in your relationship, One pair can match student IDs and the other, the week of the year.)

           

          Sum(relatedtable::field) will return the sum of "field" for all records related to the current record.

          • 2. Re: Attendance Sheet
            sly_1
              

            im not even sure how to setup the calendar part itself.

             

             

            S

            • 3. Re: Attendance Sheet
              etripoli
                 Setting up individual attendance records to look like an actual calendar can be very tricky, and you have to ask yourself if it's really necessary.  Especially if you need to enter attendance for multiple students at once - a calendar view would probably be limited to showing you the attendance for only 1, or maybe a few students at once.
              • 4. Re: Attendance Sheet
                comment_1
                  

                PhilModJunk wrote:
                WeekofYear(datefield) & " " & Year(datefield)

                I don't think that's a good idea, as it will break on weeks spanning a year break.

                • 5. Re: Attendance Sheet
                  sly_1
                    

                  ok how would this work,

                   

                  I create a new table called attendance, and I have a date field with drop down calendar and a hrs field.

                  Then you just pick the date the student came and enter hrs that way.

                   

                  how would that work

                   

                  S

                  • 6. Re: Attendance Sheet
                    davidanders
                      

                    SeedCode has a free calendar template

                    http://www.seedcode.com/downloads/downloads.php

                    (it's at the bottom) 

                    • 7. Re: Attendance Sheet
                      sly_1
                        

                      Its really not a calendar that I need. I just need a way to keep track of the students that's come on what day and for how may hours.

                      then create a report that will list me like so

                       

                      Month day year

                                studentname            hrs

                                student name           hrs

                                student name           hrs

                      • 8. Re: Attendance Sheet
                        philmodjunk
                          

                        comment wrote:

                        PhilModJunk wrote:
                        WeekofYear(datefield) & " " & Year(datefield)

                        I don't think that's a good idea, as it will break on weeks spanning a year break.


                        Thanks for catching that error. You could use: WeekOfYearFiscal(date;startingDay), where starting day would be your first day of school.


                        • 9. Re: Attendance Sheet
                          comment_1
                            

                          PhilModJunk wrote:
                          You could use: WeekOfYearFiscal(date;startingDay), where starting day would be your first day of school.

                          No, you couldn't - at least not easily, because without the year it would group records of multiple years, and with the year it would break same as before. And what has the first day of school got to do with grouping by week? Assuming a week starts on Sunday, I'd go with:

                           

                          AttendanceDate - DayOfWeek ( AttendanceDate ) + 1

                           

                          to return the starting Sunday of the week.

                          • 10. Re: Attendance Sheet
                            philmodjunk
                              

                            Thanks Comment, I should read the help file before posting such a suggestion. :smileysad:

                             

                            Now that I think it through, I suspect that the original suggestion will work just fine. Your comments are absolutely correct, but I don't think they'll be an issue in the actual situation.

                             

                            Unless this  is a very unusual school, the students will not be attending during the last week of December (they'd be on winter break) and thus the "broken week" issue won't occur.

                             

                            So unless there is some chance that students are attending duiring the last week of the year, weekofyear(datefield) & " " & year(datefield) will work as a key for identifying all attendance records of a given week.

                            • 11. Re: Attendance Sheet
                              sly_1
                                 this is a tutoring centre so students attend all year round
                              • 12. Re: Attendance Sheet
                                comment_1
                                   I think I'll mark this thread as the perfect example of what "good practice" means.
                                • 13. Re: Attendance Sheet
                                  sly_1
                                     What do you mean by good practices. Did i ask or do something wrong?
                                  • 14. Re: Attendance Sheet
                                    comment_1
                                      

                                    slyomega wrote:
                                    Did i ask or do something wrong?

                                    Not at all.


                                    1 2 Previous Next