ftp://195.146.205.14/Utilisateurs/Bernhart/

don't accept anonymous access.

Try this:

  SELECT Etats.nPoscat, ;
    Etats.ccat_physiq  ,; 
    Etats.ntype , ;
    COUNT( DatesFiltred.ddate ) Ncat, ;
    Etats.ltransfert  ;
    FROM FORCE DatesFiltred JOIN Etats  ;
    ON Etats.nPoscat = DatesFiltred.nPoscat AND Etats.ntype=DatesFiltred.ntype ;
    GROUP BY  ltransfert , Etats.ntype , Etats.nPoscat ; && IMPLICIT ORDER ON VFP
    INTO CURSOR Sum_Categ_per_periode

  SELECT Etats.nPoscat, ;
    Etats.ccat_physiq  ,; 
    Etats.ntype , ;
    COUNT( DatesFiltred.ddate ) Ncat, ;
    Etats.ltransfert  ;
    FROM DatesFiltred JOIN FORCE  Etats  ;
    ON Etats.nPoscat = DatesFiltred.nPoscat AND Etats.ntype=DatesFiltred.ntype ;
    GROUP BY  ltransfert , Etats.ntype , Etats.nPoscat ; && IMPLICIT ORDER ON VFP
    INTO CURSOR Sum_Categ_per_periode

without index and with 1 or two index.

post :

SELECT SUM(Ncat) FROM Sum_Categ
and
SELECT SUM(Ncat) FROM Sum_Categ_per_periode