I have the following Query...
I want a 3rd column which indicates the count when X='N', but I'm drawing a blank.
Any assistance would be greatly appreciated. ray:
Code:
SELECT [Location], Count(X) AS CountOfX
FROM TempQuery
WHERE [Region]="Madagascar" AND X="Y"
GROUP BY [Location]
I want a 3rd column which indicates the count when X='N', but I'm drawing a blank.
Any assistance would be greatly appreciated. ray: