dolano
2nd cousin of Rincewind
- Local time
- Today, 14:35
- Joined
- Jul 19, 2006
- Messages
- 28
This is a frustrating problem, I want to count all entries in a field that are "N" but instead of displaying the total count ie 120 i want it to show 0 until "N" is replaced by "Y". what I have got so far is
SELECT [CABLE DATA QUERY].TOP, Count([CABLE DATA QUERY].[Cable Test]) AS [CountOfCable Test]
FROM [CABLE DATA QUERY]
WHERE ((([CABLE DATA QUERY].[Cable Test]) Not Like "y"))
GROUP BY [CABLE DATA QUERY].TOP;
I know this will count everything in the field that is not Y and return the count of those values however is there a way of getting an inverse count.
SELECT [CABLE DATA QUERY].TOP, Count([CABLE DATA QUERY].[Cable Test]) AS [CountOfCable Test]
FROM [CABLE DATA QUERY]
WHERE ((([CABLE DATA QUERY].[Cable Test]) Not Like "y"))
GROUP BY [CABLE DATA QUERY].TOP;
I know this will count everything in the field that is not Y and return the count of those values however is there a way of getting an inverse count.
