Do not want to popup parameter query

[chuki2]

Hello friends, i have problem with my query..

SELECT tblProduct.type, tblProduct.model AS Model, Count(tblProduct.model) AS qty, tblProduct.cost, [qty]*[cost] AS TotalFROM tblProduct
GROUP BY tblProduct.type, tblProduct.model, tblProduct.cost, [qty]*[cost], tblProduct.buyDate
HAVING (((tblProduct.buyDate) Is Null));

When I run query, will appear popup parameter.. So I think the problem come from QTY... But I just click ok, the result everything is correct.

How if I don`t want popup parameter?

If I don`t use QTY, how I can count the quantity item and multiple the cost by group?



Thanks for help

[June7]

Don't include the Total calculation in GROUP BY, set it as Expression in the Total row of query design grid.
SELECT tblProduct.type, tblProduct.model AS Model, Count(tblProduct.model) AS qty, tblProduct.cost, Qty*[cost] AS Total FROM tblProduct
GROUP BY tblProduct.type, tblProduct.model, tblProduct.cost, tblProduct.buyDate
HAVING (((tblProduct.buyDate) Is Null));

[chuki2]

Thanks my friend.. It`s work!

Hehe