Here is my SQL statement: SELECT `tkid`,COUNT(*) FROM `xd2e_trooptrack_attendee` WHERE `costumeid` <> 20 AND `costumeid` <> 21 AND `costumeid` <> 31 GROUP BY `tkid` When I put this in phpMyAdmin ...

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it. The Count function helps you easily create a ...