Need help removing rows from a Notes, when there is no specific word to use to exclude

[lscanlon]

Hi:

I have a table the contains Notes. The notes expand multiple rows which are not the same in every case.  See example below...   I can't select on a specific Row #. I can't  select on specific words because you have no words in common on which to select for each ID.

The only thing I have to go on is that on the report I'm creating 

there is a line --------------------------------------------------------

There a bunch of NOTES

   NOTES

  NOTE

At the end of the notes there is the word CULTURE

QUESTION:  How do I remove the Notes between the lines and the word CULTURE without just saying  does not CONTAIN ([NOTE], "anything").

id  row   Note

A     1       Yes dkfdaldfj

A      2      ---------------------------------------------------

A      3       CULTURE

A      4       no dadalit

A      5       anything

B     1       could say anything

B     2       xxxxxx

B     3       ---------------------------------------------------

B     4       CULTURE

Thanks, Lenore Scanlon

[lscanlon]

Thanks very much. This really helped