Need sql to count records in a table
Posted on 2008-10-28
I have a table (tblCustomers) with a field "DomainName". I want to be able to create a function that will return an integer with the number of records in tblCustomers where the criteria is a specific DomainName value. In other words, for any specified domain name, I want to be able to have the function return the number of records containing that specific domain name within the field DomainName.