David Biddulph wrote:
"Graham Haughs" wrote in message
...

David Biddulph wrote:

"Graham Haughs" wrote in message
. ..


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.


Auto-filter for records which contain ~* should work. Precede your
asterisk by a tilde in the search criterion.


Thanks David , that works fine to select those with an * but I want to
select those without. I tried <~* and other permutations but does not
seem to work. Probably something simple I am missing.


In that case, I would Auto-filter for "does not contain" ~*

Nice one David. Many thanks for that.

Graham