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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.