Report Problem

  • Thread starter Thread starter Andre Adams
  • Start date Start date
A

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?
 
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
 
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?]));
 
Back
Top