Ulises,
Change your query as follows:

SELECT ALLTRIM(connombre)+" "+ALLTRIM(conapellidos),;
  COUNT(Modelos.modid);
 FROM  ipmsdata!concursantes LEFT OUTER JOIN ipmsdata!modelos ;
   ON  Concursantes.conid = Modelos.conid;
 HAVING count(Modelos.modid) > 4;
 GROUP BY Modelos.conid;
 ORDER BY 2 DESC

HTH

>Hi all:
>I built a view with the view builder. The SQL looks like this:
>
>SELECT ALLTRIM(connombre)+" "+ALLTRIM(conapellidos),;
> COUNT(Modelos.modid);
> FROM ipmsdata!concursantes LEFT OUTER JOIN ipmsdata!modelos ;
> ON Concursantes.conid = Modelos.conid;
> WHERE count(Modelos.modid) > 4;
> GROUP BY Modelos.conid;
> ORDER BY 2 DESC
>
>If I try to run the form where I have a grid based on this view I get the following error message:
>
>"Error loading file-record number 7.Form1 . Loading form or the data environment: File 'count.prg' does not exist"
>
>If I remove the filter (the WHERE clause) the form loads correctly, but I don't have the information as I need it. What causes that an expression being evaluated or considered as a .prg file? That expression is built with the expression builder, so it should be ok... or not?
>TIA for your time.
>Ulises

Daniel