>>I have a report that is based on a view that uses variables that are selected from a form. How do I return a message if the resultant view doesn't match the selection data that was entered in the form. In the old days, I could use:
>>
>>if _tally = 0
>>
>>after my select statement. But now I don't seem to have that kind of control.
>>
>>Thank you.
>
>How about RECCOUNT()
>
>Craig

Perhaps I didn't make myself clear. Sorry. Yes, Reccount() would have worked in the 2.6 days after running a SELECT statement. However, this report uses a view in the data enviornment, so I (seemingly) have no control of the SQL, or cannot test the RECCOUNT() or _TALLY like I used to do. Therefore, is there anyway to send a message to a user telling them their selection criteria returned no records?