Help with finding dates & counting

[msix]

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.

[comment]

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

Which week is "the week"?

[LaRetta]

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.

[msix]

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?

[comment]

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.

[msix]

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.

[comment]

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