Parmeter Box pop up!

[sashapixie]

Hello There

I have the following query set up in my access 2013 database:

SELECT [PPE Products Detail Taken by Staff].[Product Description], [PPE Product List].Quantity, Sum([PPE Products Detail Taken by Staff].Quantity) AS SumOfQuantity, [PPE Product List]![Quantity]-[SumOfQuantity] AS [Stock Level]
FROM [PPE Product List] INNER JOIN [PPE Products Detail Taken by Staff] ON [PPE Product List].[Product ID] = [PPE Products Detail Taken by Staff].[Product Description]
GROUP BY [PPE Products Detail Taken by Staff].[Product Description], [PPE Product List].Quantity, [PPE Product List]![Quantity]-[SumOfQuantity];

Everytime I open the query the parameter pop up box appears asking for SumofQuantity, however when I run the query it works with no data needing to be entered, how can I stop this box appearing??

Thanks

 

[Norie]

Try replacing [SumOfQuantity] with Sum([PPE Products Detail Taken by Staff].Quantity) in the [Stock Level] expression and in the GROUP BY clause.

 

[sashapixie]

Hi There Norie

If I do this then it does not calculate correctly, with SumofQuantity I get the below result

Product Description Quantity SumOfQuantity Stock Level
High Viz Vest - Large 20 11 9
Goggles 10 5 5

with the changes you mentioned in your post this then becomes

Product Description Quantity SumOfQuantity Stock Level
High Viz Vest - Large 20 10 10
High Viz Vest - Large 20 1 19
Goggles 10 4 8
Goggles 10 1 9

I want the top result which works with the Sum of Quantity I just don't want the pop up box.