Re: Query/400: How do you removeduplicaterecordinformation on a Report?

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