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

"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

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

"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

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