M
Maurita
I hope someone can help with a strange counting problem I'm having in
a report. I have a form that sums together all criteria in a
particular field for all records; for example: System1, System 2.
Each system has the totals of Run Time and Available Hours in separate
fields. The problem I am having is in the Available Hours field. The
code works fine to get the correct value =(How Many Weekdays]*22.5)
But, I need to total the amount from System1 and System2 in the Report
Footer. Since both systems reference a total of 10 records, I am not
getting the correct Available Hours. Instead of totaling the
Available Hours for System1 and System2, Access is using the total for
10 records instead. For Available Hours of 150.00 for System1 and
150.00 for System2 totaling 300.00, Access is totaling for 10 records
for 1500.00.
I have tried several code combinations and have spent hours on this.
Any help is greatly appreciated.
Thank you.
Maurita Searcy
a report. I have a form that sums together all criteria in a
particular field for all records; for example: System1, System 2.
Each system has the totals of Run Time and Available Hours in separate
fields. The problem I am having is in the Available Hours field. The
code works fine to get the correct value =(How Many Weekdays]*22.5)
But, I need to total the amount from System1 and System2 in the Report
Footer. Since both systems reference a total of 10 records, I am not
getting the correct Available Hours. Instead of totaling the
Available Hours for System1 and System2, Access is using the total for
10 records instead. For Available Hours of 150.00 for System1 and
150.00 for System2 totaling 300.00, Access is totaling for 10 records
for 1500.00.
I have tried several code combinations and have spent hours on this.
Any help is greatly appreciated.
Thank you.
Maurita Searcy