Query on Date

[niconic]

Hi everyone,

I am building a church database monitoring Attendance.

I am building a query to list Church members who have missed 3 weeks in a row.

I've searched through the date criteria and something isn't configured right.

For simplicity of explaining I have:
[Attendance]Form

ID (PK)
Member Name (Text)
Service Date (Date & Time)
Present (Yes/No).

So I have multiple entries of members of who missed church.

In my query, it list's:
Member Name
Present {Criteria}=False
Service Date {Criteria}In (#6/5/2011#,#6/12/2011#,#6/19/2011#)

Which works, but it list's all three entries, and not just 1 member name. How can I get that to work?

If you want you can look at the database and see what I am talking about.

Thank you so much for any input.

[Rhino373]

This all depends. The easiest way is to create a second query based off the first which is a Totals query. You'd add only one field [Member Name] and group by it.

[niconic]

I'll try that, thanks.