Attendance Report

i have a database that holds all the information about our clients. We have
an outpatient program which is billed according to how many group sessions
they attend. What I'd like to do is generate a report that shows which
clients attended group on a particular day. I have a ClientInfo table related
to a OPAttend table. In the OPAttend table there is a field for group session
date and a Yes/No field to mark if they attended or not. I'm just not sure
how to set the report up. Any suggestions?

Create a query that joins the ClientInfo table and the OPAttend table on the
Client ID. Do not filter the query. Use this query as the record source of
your report. Do the filtering of the report in the Where clause of the
OpenReport method. This gives you more flexibility.
I do have one question, if you have a patient suffering from MPD, do you
count him as one attendance, or do you count one attendance per personality?

(sorry, I can't help myself, somtimes)
--
Dave Hargis, Microsoft Access MVP


"robertm600635" wrote:

i have a database that holds all the information about our clients. We have
an outpatient program which is billed according to how many group sessions
they attend. What I'd like to do is generate a report that shows which
clients attended group on a particular day. I have a ClientInfo table related
to a OPAttend table. In the OPAttend table there is a field for group session
date and a Yes/No field to mark if they attended or not. I'm just not sure
how to set the report up. Any suggestions?