Too Few Parameters -- Expected 1. 1

[milton747]

I get: Too Few Parameters -- Expected 1.
TOT3 is suumming the all order values with a city.
Any assistance. My SQL skills are light I'm afraid.
Milt.



SELECT
OrdersByCity.city, OrdersByCity.orderID,
(OrdersByCity.pricequote * OrdersByCity.quantity) As TOT2,

(SELECT SUM(TOT2)
FROM OrdersByCity T1
WHERE T1.city = OrdersByCity.city) AS TOT3

FROM OrdersByCity
ORDER BY
OrdersByCity.city,
OrdersByCity.orderID

-- End ---

 

[Melagan]

You can't use alias with aggregate functions. Try this:

SELECT
OrdersByCity.city, OrdersByCity.orderID,
(OrdersByCity.pricequote * OrdersByCity.quantity) As TOT2,

(SELECT SUM(t1.pricequote * t.quantity) as TheSum
FROM OrdersByCity T1
WHERE T1.city  = OrdersByCity.city) AS TOT3

FROM OrdersByCity
ORDER BY
OrdersByCity.city,
OrdersByCity.orderID

~Melagan
______
"It's never too late to become what you might have been.

 

[milton747]

Thanks Melagan.
I just tried the SQL and it works good in my report.

Big Thanks.
Milt.