AnsweredAssumed Answered

How to create a weekly report

Question asked by tessgold on Jul 30, 2009
Latest reply on Aug 1, 2009 by comment_1


How to create a weekly report


I'm new to FM and am having the hardest time figuring out how to create what I thought would be a simple report. I hope someone can clue me in.


I need to keep track of daily attendance at our organization's playgroups. No problem. I have a table for Client List and another for Playgroup Attendance. We enter each client's dates of attendance and I had no trouble creating a report that lists the total attendance on any particular date. I even added a DayName field so I could easily see what day of the week is associated with each date.


My problem is that it would be nice if I could structure the report so that it would automatically add up a week's attendance for me (Monday thru Friday). I've got over 2 years of data and just need to find an easy way to organize it.


I'm sure I must be overlooking something very basic, because I would think that a lot of people need to do this, but I can't figure it out and I can't find any help in any of the documentation.


I'd appreciate any help anyone can give me.


thanks, Tess