>It just occured to me that when I use the reccount() function or an SQL count function it counts the deleted entries (the ones with their "squares" black) and I don't want those included in my totals.

Either do an SQL SELECT with SET DELETE ON and check the result of that, or you can use the COUNT command.