Hi Chris,

How about:

SELECT mynumber, COUNT(*) AS modecount ;
    FROM mytable ;
    GROUP BY 1 ;
    ORDER BY 2 DESC ;
    INTO CURSOR mycursor

The first record in the cursor will contain the most common number.

Hope this helps,
Gavin...

>Hi All
>
>We need to calculate the mode (most commonly occurring number) from a list of values - excel can do it with the MODE() function - does anyone know if VFP can do something similar?
>
>Cheers
>
>Chris Kable