Report Problem

[Andre Adams]

Can anybody help?

I had 2000 records (Quantity and Price) that I imported into access that I
created a table with. Out of the table, I created a query that would sum
the quantiy and group the price. This created a reasonable amount of trades
to display in a report format so I created a report. The report however does
not show the Sum of the quantities that's listed in the query. Is there a
reason why this is happening?

 

[mscertified]

Can you post the SQL of the query feeding the report.
Unless your query contains a column with the sum you want, you will need to
sum whatever column you need in the report itself.

-Dorian

 

[Andre Adams]

The SQL is below.

SELECT Sum(tblBuybackSpreadsheet.QUANTITY) AS SumOfQUANTITY,
tblBuybackSpreadsheet.PRICE, [SumOfQUANTITY]*[PRICE] AS Principal,
[SumOfQUANTITY]*0.02 AS Commission, [Principal]-[Commission] AS [Net Money]
FROM tblBuybackSpreadsheet
WHERE (((tblBuybackSpreadsheet.DATE)=[What date are you looking for?]))
GROUP BY tblBuybackSpreadsheet.PRICE, [SumOfQUANTITY]*[PRICE],
[SumOfQUANTITY]*0.02, [Principal]-[Commission], tblBuybackSpreadsheet.SYMBOL
HAVING (((tblBuybackSpreadsheet.SYMBOL)=[What Symbol are you looking for?]));