>>Hi,
>>
>>I try to find distinct values in a group with a query like this:
>>
>>select id1, count(distinct 'field') as cntfld form table1 group by id1
>>
>>and values in cntfld is incorrect, different from second aproach like this:
>>
>>select distinct 'field' from table1 where id1=somevalue
>>
>>number of records in second case is different from cntfld form first case for same value of id1
>>
>>In SQL server first form of select works ok. In VFP is something wrong?
>>
>>Thanks
>
>post a 2 records example

sorry, my mistake