Hi Davis Unwin and Lucas Geheniau:

Thank you both for your replies (copied below).

I set the Quantity On Hand Field to have a Report
Summary Function of "Average."

The results are:

1. For the Item No. Sub-Total, this works fine and
gives the correct Quantity On Hand balance.

2. For the Report Totals, it creates a number for the
Quantity On Hand that is meaningless.  

For now, I am manually correcting this number and I'll
continue to do so until another suggestion comes my
way.  :-)

Regards,
Al Gershen
Cost Accountant Lead
ECS Composites
3560 Rogue River Hwy
Grants Pass, OR 97527
Tele (541) 476-8871, x272
Fax (541) 474-2479
aldg3@xxxxxxxxx



--- "Unwin, David" <dunwin@xxxxxxxxxx> wrote on Tue, 8
Aug 2006 11:47:02 +0100:

Hi Al,

The only way you can get round this is to use the
Average, Minimum or
Maximum summary function for the on hand column.

Kind regards,

David.



--- Lucas Geheniau <geheniau@xxxxxxxxxxxxxxxxxx> wrote
on Mon, 07 Aug 2006 08:32:05 +0200:

Hi Al,

If you want the on hand qty correct in the
subtotals, choose min(or max or 
avg) at the summary functions for that column.

Kind regards

Lucas



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 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.