Report showing BOTH Aggregate Sum of Display records and Total Sum by Group
Based on another posting I have just read...it appears I want to sum all
the "master records" (host table in the left join from the SQL statement in
the group footer, but only display the "child records" in the Detail
section.
Hope this helps you help me!!!!
Quote:
> This is one that has me stumped.............
> I have a database detailing cost reductions by buyer. These are stored
in
> tblCostReductions. Another table, tblSuppliers, shows all the suppliers
by
> buyer with their respective annualized purchase dollars.
> A rough idea of the structure of the tables is as follows:
> tblCostReductions tblSuppliers tblBuyer
> --------------------------- ------------------ -------------
> Buyer# SupplierNbr Buyer#
> SupplierNbr Buyer BuyerName
> Amount of Reduction($$) AnnualizedPurchases Director
> Division Affected SupplierName
> What I have as a report is:
> --------------------------------------
> Purchases Div1 Div2 Div3 Total
> Supplier#ABC $500K $11K $0 $50K $ 61K
> Supplier#DEF $900K $56K $44K $0 $ 99K
---------------------------------------------------------------------------
-
Quote:
> -----------------------------------------------------------------
> Buyer123 SubTot $1400K $67K $44K
Quote:
> 11.4%
> What I would like to see is:
> ---------------------------------------
> Purchases Div1 Div2 Div3 Total
> Supplier#ABC $500K $11K $0 $50K $ 61K
> Supplier#DEF $900K $56K $44K $0 $ 99K
Quote:
> -----------------------------------------------------------------
> Buyer123 SubTot $1400K $67K $44K
Quote:
> 11.4%
> Buyer123 Total $6000K
2.6%
Quote:
> I have tried the MoveNext property along with making records without any
> cost reductions not visible, but no luck.
> Any suggestions.......Code or macros welcome. Version 2.0.
> Thanks in advance,
> ken jones
