... >SELECT LettersForThisPatient >report form ViewReferralLetter preview >... >The above did it. Thanks Sergey.
SELECT * FROM LettersForThisPatient IF _TALLY = 0 * No records returned >* Show a from that tells the user that there are no records to display else * Do all the dat gathering and display the reportWhat I see happening is the cursor being displayed on screen before the report is display. Actually I would not want the cursor to show up at all. I even put "Select * from LettersForThisPatient noconsole" and it still showed up on screen.