G
Guest
Hi, I'm generating an Access 2000 report off of information in a table. In
essence, the report lists the fields: Client, Pieces, and Cost. So I have a
report like:
Client Pieces Cost
ABC Co. 150 $198
XYZ Co. 380 $671
Test Inc. 275 $495
Totals 3 805 XXX
The "XXX" would be a weighted average of the Pieces count and the Cost. For
instance: (150/805 * $198) + (380/805 * $671) + (275/805 * $495) = $523.
However, I'm afraid I don't know how to "program" this type of formula into
the Totals line of my report. I'd appreciate whatever help folks could
provide. Thanks very much.
essence, the report lists the fields: Client, Pieces, and Cost. So I have a
report like:
Client Pieces Cost
ABC Co. 150 $198
XYZ Co. 380 $671
Test Inc. 275 $495
Totals 3 805 XXX
The "XXX" would be a weighted average of the Pieces count and the Cost. For
instance: (150/805 * $198) + (380/805 * $671) + (275/805 * $495) = $523.
However, I'm afraid I don't know how to "program" this type of formula into
the Totals line of my report. I'd appreciate whatever help folks could
provide. Thanks very much.