Attendance Report

R

robertm600635

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?
 
K

Klatuu

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top