rmoving a blank line from a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Well, you could change the query Unique Records property to yes or the
RecordSet Type to Snapshot. Either on of those should drop the blank line
(assuming that there is no actual record where all the displayed fields are
blank).

The empty row is a place to enter a NEW record when the query result is
updatable. On reports the empty row for a new record should NOT be counted
and the reports NoData event should be triggered. If that is not happening,
I would suspect that you have a saved blank record in your data.
 
Back
Top