V
Vernon
This is my first post ever, hope I do it correctly.
I have a report that uses a query as a record source that combines three
tables.
In the query I have used Sum and GroupBy. The report is grouped by Therapist
then Dayofweek. Each Therapist can filter the report by Therapist name
and/or Dayofweek to view their clients and the days of their meetings for the
month. The detail section is as follows.
ClientName, Source,Treatment, StartDate, ,DOM, DOM, DOM, DOM (, as marker)
where DOM is the date for the day of the month of each meeting.
I would like to pull data from an attendance/payment table to show that the
client was present on a certain date. If I add the table to the query, I get
a record for each client repeated four time, one for each DOM which
quadrauples the number of records I want.
How can the data be extracted from the attendance/payment table without
changing the record source query?
Any and all suggested procedures would be appreciated.
Thanks, Vernon
I have a report that uses a query as a record source that combines three
tables.
In the query I have used Sum and GroupBy. The report is grouped by Therapist
then Dayofweek. Each Therapist can filter the report by Therapist name
and/or Dayofweek to view their clients and the days of their meetings for the
month. The detail section is as follows.
ClientName, Source,Treatment, StartDate, ,DOM, DOM, DOM, DOM (, as marker)
where DOM is the date for the day of the month of each meeting.
I would like to pull data from an attendance/payment table to show that the
client was present on a certain date. If I add the table to the query, I get
a record for each client repeated four time, one for each DOM which
quadrauples the number of records I want.
How can the data be extracted from the attendance/payment table without
changing the record source query?
Any and all suggested procedures would be appreciated.
Thanks, Vernon