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

Advanced filter with *
 

"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.
--
David Biddulph

Advanced filter with *
 

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.

Graham

Advanced filter with *
 

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

Advanced filter with *
 

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