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.