>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) FROM mytable