How 2 avoid sub-reports?

[Faraz A. Qureshi]

I have a query always calculating the totals of five different products and
the result being:

Product A Total Amount (or 0 in case of null)
Product B Total Amount (or 0 in case of null)
Product C Total Amount (or 0 in case of null)
Product D Total Amount (or 0 in case of null)
Product E Total Amount (or 0 in case of null)

Now I want to make/design a report based upon such a query, however, I want
each of the entry, i.e. the sum of the products be placed manually at
different locations of the page instead of being presented in a tabular form.

In other words, instead of treating these to be treated as TWO fields i.e.
Product & Amount, I want them to be treated as five fields of SumProductA,
SumProductB, SumProductC, SumProductD and SumProductE.

Please HELP!

 

[Arvin Meyer [MVP]]

Use a crosstab query as the source of your report.

 

[De Jager]

I have a query always calculating the totals of five different products and
the result being:

Product A Total Amount (or 0 in case of null)
Product B Total Amount (or 0 in case of null)
Product C Total Amount (or 0 in case of null)
Product D Total Amount (or 0 in case of null)
Product E Total Amount (or 0 in case of null)

Now I want to make/design a report based upon such a query, however, I
want
each of the entry, i.e. the sum of the products be placed manually at
different locations of the page instead of being presented in a tabular
form.

In other words, instead of treating these to be treated as TWO fields i.e.
Product & Amount, I want them to be treated as five fields of SumProductA,
SumProductB, SumProductC, SumProductD and SumProductE.

Please HELP!