I use the following SQL select query in MS Access to generate result on large input data:
SELECT "1.01" AS Item ,"Name" AS Test ,Count([Item]) AS [Count] ,Sum(IIf([Results] = "Invalid", 1, 0)) AS [# Invalid] FROM [Test 1-01] GROUP BY "1.01" ,"Name" ,"Yes";
I got an...