Thanks, this seems to work great in VFP 5
>>Hi all,
>>
>>Is there a (sql) command that can calculate the number of unique records of a field into a table with just one command in VFP 5?
>>
>>Thanks beforehand.
>
>How about
>
>
SELECT COUNT (DISTINCT yourfield) FROM yourTable INTO ARRAY aTemp