Advanced filter with *
I have a database where one of the records is made up of some notes. Once
the notes have been processed an * is put at the start of the first letter
of the first sentence to show that it has been dealt with. All I want to do
is select out all the records which do not have an * in that particular
record. I appreciate it is a wildcard character, and I understand it would
be simpler to create another Y/N record but the circumstances do not allow
that in this situation so I would be grateful if anyone could advise me if
there is there any way to set the criteria to allow this selection.
Kind regards
Graham Haughs
|