Customers scan their bar code when coming into the club. The scanner records their bar code ID, also their member ID, and creates a new record that records the member ID and the current date.

How do I find all of the members that attended for the week, where my weekday starts on a Monday and ends on a Saturday?

1. I need to list each member name & member ID & the date attended

2. I need to tally up the total # of members attended each day as well as for the entire week.

Thanks.

How do I find all of the members that attended for the week

Which week is "the week"?

I would assume if they fell within the date attended. Calculation something like: DateAttended - DayOfWeek ( DateAttended + 1 ) then group by this calculation in sub-summary report.

If Monday thru Saturday is my week (I'm not open on Sundays), and say today is Friday, I'd want to see all of the attendees from Monday thru today (Friday). I also run a daily report, but I like to see the progression as the attendance builds through the week. Does that help?

This script will find records of the current week (week starting on Monday)

Enter Find Mode[]

Set Field [ Datefield ; Let ( [

today = Get (CurrentDate) ;

mon = today - DayOfWeek ( today - 1 ) + 1

] ;

mon & ".." & mon + 6

) ]

Perform Find[]

To get the daily/weekly counts, create a report with a sub-summary by Datefield part and a grand summary part, and place a summary field defined as Count of in both parts.

I'm missing something here. Is DateField a new field I need to define? Is it a date or a calculation field if so. I tried the script and it's asking for a contstant.

Datefield is the name I used to indicate your existing date field - where the date of entry is recorded.