Advanced filter with *

[Graham Haughs]

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

 

[David Biddulph]

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.

 

[Graham Haughs]

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.

Graham

 

[David Biddulph]

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" ~*

 

[Graham Haughs]

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

Nice one David. Many thanks for that.

Graham