>>>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

>
>Are you sure this would work in VFP5?

Pretty sure. Actually, I think this syntax is valid as far back as 2.6 but can't validate that from where I am now.