Help on Report Design

[Andy Braunston]

Hi,

I am new to Access.........I have got a basic church database design with
three main tables - contacts, services and the link table of attendance
showing who came to which table. I now need to get information out of the
database. I want reports which tell me
how many came to each service
who hasn't been for x weeks
whose birthday is in the next y weeks

Am working my way through "Access for Dummies" but thought some one out
there may have some ideas.

ta

Andy

 

[Duane Hookom]

Please try to ask a single question. I believe it improves your chances at
getting a reply.
It would also help to know how you are storing attendance. Without seeing
your tables, to get the attendance by service:

SELECT ServiceDate, ServiceName, Count(*) as Attendees
FROM tblServices S JOIN tblAttendance A on S.ServiceID = A.ServiceID
GROUP BY ServiceDate, ServiceName;