×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.



  1.  Home
  2. MIDRANGE-L
  3. April 2008

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




This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.