>This is probably a repeat question but here goes anyway
>
>I need to Count the number of records from a table on Distinct values of one field other that using the reccount function.

select count( distinct myField) as myDistCount from myTable