>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
If it's not broken, fix it until it is.
My Blog