Databases Reference
In-Depth Information
° Now, click on the
To
button and set the
Cell Index Position
to
1
From Bottom
. Click on
OK
.
° Click on the
Select
button and set the
Select
value to
1
and the
Skip
value
to
0
. Click on OK:
6.
Click on the
Add
button to include this second condition and then click
on
OK
.
Now, the two conditions will be evaluated and those rows that match both
conditions will be removed.
We had to apply both conditions because if we had only specified the "contains Date"
condition the first row would have been removed as well.
Furthermore, if we had deleted line 27 directly by marking it with the mouse and by
clicking on the
Delete Marked
button, even though the effect would have been what
we expected, the final code instruction would always look for line 27 and remove it,
without first evaluating if that's actually a garbage line. What would happen when
the report is updated? Who knows if the garbage line will still be line 27. You can't
be sure. It's better to apply a certain logic so that even when you update the report,
the code can automatically identify the garbage line.