You mean the browse window that comes up? To get rid of that, you need to put the results into something. If you don't specify where it goes, it just displays the query. I've never heard of using NOCONSOLE with SQL SELECT. If you're meaning the progress bar, use SET TALK OFF.
Michelle
>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
>>