Enter Parameter Value

[sharkchaser]

If I pull out the WHERE clause this works well.

What I need is to filter by the WHERE clause and ORDER BY Volume DESC.


SELECT listofficename, sum(closeprice) AS VOLUME
FROM tblCARETSdata
WHERE Volume > '10000'
GROUP BY listofficename ;

I'm trying to figure this out from "Simply SQL" but I'm missing something here.

Thanks.

Rick

 

[SkipVought]

Hi,

is Volume a TEXT field??? I'd wager NOT!

WHERE  Volume >  10000

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

Volume can't be resolved in the Access query. Try:

SELECT listofficename, sum(closeprice) AS VOLUME
FROM tblCARETSdata
GROUP BY listofficename  
Having  sum(closeprice) >  10000;

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

And for the sort:

SELECT listofficename, Sum(closeprice) AS VOLUME
FROM tblCARETSdata
GROUP BY listofficename  
HAVING Sum(closeprice) > 10000
ORDER BY 2 DESC

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886