Or, as Yogi would say, Deja Vu ALL OVER AGAIN.
It's just that we use QRY/400 all the time, and 99% of the time, it does
what we need. Just wanted to make sure there was not a little trick I
did not know about.
Thanks, Rob.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, April 08, 2008 10:44 AM
To: Midrange Systems Technical Discussion
Subject: Re: Calculation at Sub-total level with qry400
Have you looked at CRTQMQRY and that genre?
And I sense Deja Vu with your question. It sounds very familiar...
Maybe a SQL statement like
Select Item#,Vend#,Delivery,Qty,Price,Extended
from thatTable
union all
(Select Item#,null,null, sum(qty), sum(extended)/sum(qty), sum(extended)
from thatTable Group by Item#)
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
"Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/08/2008 10:56 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc
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
midrange.com
