C
Chuck Moore
It has been a while since I have built an Access database with Main Form/Sub
Form relationships.
The Main Form allows a user to select a date range using Between from all of
the dates within my main audit table. Fields in the forms datasource query
are autTreatReleaseAuditID, dtmAuditDate w criteria Between[Start
Date]And[End Date], Expr1: [Start Date],
And Expr2: [End Date]. I also have one more field autTreatReleaseAuditID
set to count. This gives me the total number of audits recorded over the
selected dates. There are on the average 120 audits per date.
Each of the sub forms displays the totals of certain record counts. Each of
the sub forms works perfectly without a date parameter and when tested with a
date parameter reflect the proper totals. For example, one sub form totals
the number of patients identified through Triage for Discharge. Fields in
the sub forms datasource query are autTreatReleaseAuditID, autSortCategoryID
with criteria = 1, autSortCategoryID set to Count and dtmAuditDate. The only
control on the sub form has a Control Source of
=Sum([CountOfautSortCategoryID]).
I have tried every possible combination of Childfield/Masterfield that I can
think of using autTreatReleaseAuditID and CountOfautSortCategoryID and none
of the combinations present the proper totals.
HELP!
Form relationships.
The Main Form allows a user to select a date range using Between from all of
the dates within my main audit table. Fields in the forms datasource query
are autTreatReleaseAuditID, dtmAuditDate w criteria Between[Start
Date]And[End Date], Expr1: [Start Date],
And Expr2: [End Date]. I also have one more field autTreatReleaseAuditID
set to count. This gives me the total number of audits recorded over the
selected dates. There are on the average 120 audits per date.
Each of the sub forms displays the totals of certain record counts. Each of
the sub forms works perfectly without a date parameter and when tested with a
date parameter reflect the proper totals. For example, one sub form totals
the number of patients identified through Triage for Discharge. Fields in
the sub forms datasource query are autTreatReleaseAuditID, autSortCategoryID
with criteria = 1, autSortCategoryID set to Count and dtmAuditDate. The only
control on the sub form has a Control Source of
=Sum([CountOfautSortCategoryID]).
I have tried every possible combination of Childfield/Masterfield that I can
think of using autTreatReleaseAuditID and CountOfautSortCategoryID and none
of the combinations present the proper totals.
HELP!