I'm attempting to get a count of NAs in a field in a table in MS Access. I have multiple NAs:
- #N/A* (i.e. NAs that start with hash & "N/A" & some more text that varies.)
(They all mean something different for us, so it i actually useful to have the different NAs.)
This works for one specific NA, "#N/A N/A":
SELECT Count(IIf([Short Int % Eqy Flt] = '#N/A N/A' ,0 )) AS MyTotal FROM tblFirst250
The above returns 141, which seems correct.
This returns 0:
SELECT Count(IIf([Short Int % Eqy Flt] LIKE '#N/A' ,0 )) AS MyTotal FROM tblFirst250
The above should return 142 because I have 141 "#N/A N/A" and 1 "#N/A Invalid Security".
Really what I am after is something that counts all of my NAs in the [Short Int % Eqy Flt] field. See my list of NAs above.