One more question, where would I put NOCONSOLE in this statement? I have tried different spots of this SQL and some gives error message (odd) or still run with showing the results (want to hide the results and go ahead to the next line of REPORT FORM...)

Chuck

>

>SELECT P.Name, ;
>    A.AuthType, ;
>    A.Limit, ;
>    A.Fund, ;
>    A.Project, ;
>    A.Program, ;
>    A.Account, ;
>    A.SFS, ;
>    A.MCC, ;
>    O.Orgainization ;
>   FROM Org O ;
>      JOIN Author A ;
>      ON O.Organization = A.Organization
>      JOIN Person P ON A.ID = P.ID ;
>      WHERE (A.End > DATE() OR A.End={} ;
>      ORDER BY O.Orgainization, P.Name, A.AuthType
>