Query Failure

[sharkchaser]

Doesn't work. Returns empty rows.

SELECT Max([HIGH Dollar Market].ListPrice) AS MaxOfListPrice, Avg([HIGH Dollar Market].ListPrice) AS AvgOfListPrice, Min([HIGH Dollar Market].ListPrice) AS MinOfListPrice, Count([HIGH Dollar Market].City) AS CountOfCity, Avg([HIGH Dollar Market].DaysOnMarketCumulative) AS AvgOfDaysOnMarketCumulative
FROM [HIGH Dollar Market]
GROUP BY [HIGH Dollar Market].City
HAVING (((Max([HIGH Dollar Market].ListPrice))>=5000000) AND ((Avg([HIGH Dollar Market].ListPrice))>=5000000) AND ((Min([HIGH Dollar Market].ListPrice))>=5000000) AND (([HIGH Dollar Market].City)="Corona Del Mar (CDM)"));

What am I missing?

Thanks . . . Rick

 

[dhookom]

I'm not sure how we can help since we can't see your data? What have you tried so far? Typically you should remove all criteria and then add it back in a piece at a time to find out where you made a mistake.

Duane
Hook'D on Access
MS Access MVP