Calculation Problem

[Maurita]

I hope someone can help with a complex calculation problem in a
report. In this report, I am summing amounts for each system
(System1, System2, System3) by RunTime and AvailableHrs. I have the
entire report working except for totaling the AvailableHrs.

For example, the report has 10 records and with 7 days typed into a
calculation, the AvailableHrs per system for this report is 150.00. I
need to add the AvailableHrs total of System1 150, System2 150,
System3 150, for a total of 450.00. I am having trouble with my
calculations because Access keeps referencing the total records in the
report, which is 10, and totals the AvailableHrs at 1500.00.

My code for AvailableHrs that I use for System is
=([How Many Weekdays]*22.5)

I can't get the above code to add the amounts in the AvailableHrs
column. If I use SUM, Access takes the above code and multiplies by
the number of records in the report. I just need to add the amounts
in the AvailableHrs column, not reference the records in the reports.

Thank you for any help you can give.

Maurita Searcy

 

[John W. Vinson]

I hope someone can help with a complex calculation problem in a
report. In this report, I am summing amounts for each system
(System1, System2, System3) by RunTime and AvailableHrs. I have the
entire report working except for totaling the AvailableHrs.

If you are storing three fields for different systems in each record,
then your table is not properly normalized. What will you do when you
need a FOURTH system? Redesign all your tables, forms, queries,
reports...!? Maybe I'm misunderstanding the context!

For example, the report has 10 records and with 7 days typed into a
calculation, the AvailableHrs per system for this report is 150.00. I
need to add the AvailableHrs total of System1 150, System2 150,
System3 150, for a total of 450.00.

if these ARE three fields in a table you would not use Sum() at all:
to sum across fields in a record, use a calculated field in the query:

AllSystems: [System1] + [System2] + [System3]

I am having trouble with my
calculations because Access keeps referencing the total records in the
report, which is 10, and totals the AvailableHrs at 1500.00.

My code for AvailableHrs that I use for System is
=([How Many Weekdays]*22.5)

Since I have no idea whatsoever where [How Many Weekdays] comes from,
or what this is calculating, I really can't say what this should be.

I can't get the above code to add the amounts in the AvailableHrs
column. If I use SUM, Access takes the above code and multiplies by
the number of records in the report. I just need to add the amounts
in the AvailableHrs column, not reference the records in the reports.

What Tables are involved?
What's the Recordsource of the Report?
What is actually in the fields System1, System2, System3?
Where is [How Many Weekdays] coming from, and how is it connected with
SystemN?

John W. Vinson [MVP]