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.