RE: Calculation at Sub-total level with qry400

Hi Don

It's somewhat annoying, but I think you could achieve this effect by doing
the query in two passes.

First pass selects the data and outputs to a file.
Second pass does the calculations and outputs to print.

Using a second pass was also good for calculating percentages in the totals
and ordering by a result in the totals.

Haven';t thought too hard about it (just crawled out of bed) so I hope this
helps.

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Wednesday, 9 April 2008 2:56 a.m.
To: Midrange Systems Technical Discussion
Subject: Calculation at Sub-total level with qry400

Item# Vend# Delivery Qty Price Extended
860467 10380 2007/09/10 185 2.240 414.40
860467 13451 2007/10/05 400 2.630 1,052.00
860467 13451 2007/11/26 110 2.630 289.30
860467 13451 2008/04/14 24 2.630 63.12
860467 15254 2007/03/15 400 .640 256.00
860467 15254 2007/07/02 700 .640 448.00
860467 15254 2007/09/24 507 .830 420.81
860467 15254 2008/01/07 700 .830 581.00
860467 15254 2008/02/04 700 .830 581.00

TOTAL 3,726 ?????
4,105.63

I don't believe there is a way to get this MISSING "weighted average" Price
calculation: 4,105.63 divided by 3,726 performed at the sub-total level
( I know Sequel can do so).

Thanks,
Don

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman