Problem with a subreport only showing part of the information

M

Michael

I have a subreport "totalsinorders" that is supposed to show the total
weight by product from another query "order details query".

When I run the report, It only shows one of the products and the total for
this product that are in the report.

There are 6 different products that are listed by the query and the one that
does show on the report is the second one down so it is not just showing the
first and not the rest.

thank you for your help
Michael


the code of the subreport
SELECT totalsinorders.SumOfEsigenz, totalsinorders.Prodotto FROM
totalsinorders;


the code of the query

SELECT Sum([order details query].Esigenz) AS SumOfEsigenz, [order details
query].Prodotto
FROM [order details query]
GROUP BY [order details query].Prodotto;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Subreport Question 2
QBF & Query Malfunction 0
Problem with SET & REF function 0
ordering by date in a subreport 1
Total Problem 3
Total is off by a couple of cents 4
Subreport with headings 4

Top