Question

when a student is coming to day camp for a few nonconsecutive weeks for example 2 weeks in the beginning and 2 weeks in the end how do I enter his period so his name should appear on class list only during the weeks he is attending

Answer 1

You enter it in two rows. When pulling class list for each week you will need to specify by the dates on top for which time period you are looking at. If you will look at the whole period he will come up twice, once for each time.

Comments

Instead of using the dates for selecting the time period, you can use the season, We set up our system with 5 seasons, (Full Summer, First half, Second half, Misc1, Misc2) when we enter a student for 2 weeks we place them into the appropriate season, Misc1 or Misc2 and use 3 season in every report (Full, First, & Misc1 or Full, Second, & Misc2). You would still need to enter the student in 2 rows, but selecting the correct season during queries is something that's done anyway whereas selecting the dates might not be done generally.