Hello,
I am trying to write a query that will be the basis for a report. The
problem is, that there is always a blank line (for a new record) at the last
record of the query (that is, I *never* get an empty query). Sometimes, it
doesn't bother me, since if the query has any results besides the blank line,
the report won't show the blank line. But, if the query has no results, the
blank line is still there, and the report shows this blank line as a record
(while what I would want is that the report will run the NoData event).
Is there a way I can remove this blank line (either in the query itself, or
by changing something in the report)?

thanks,
Dror