Filtering in Access 97

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Noddie - 16 Mar 2007 04:33 GMT

Hi
I was wondering if some kind person could answer this question for me or
give me a leader in help for it.
I have to filter out from a database all the Client codes from a field that
looks like this

Codes for Clients

ANCD #AMRU ANRD ADNI
ACRI *EVER #ASTI

*AMRI ASST *FROT ASSU
ADDU -ADCB -MNOP ACRU

This is just to give you the idea.

I need to filter out all the codes that do not have
-
*
#
in them, leaving me with the plain codes on their own. I have tried a few
combinations and
end up just deleting the # - * ones, and then not saving the database as I
would loose all the
other codes.
Hope this makes sense, and would truly appreciate any help that may be give
to help me
better understand this sort of filter.
Thanks heaps

Nod

Reply to this Message

storrboy - 16 Mar 2007 04:40 GMT

> Hope this makes sense....

Not really. When you say

> I need to filter out all the codes that do not have
> -
> *
> #
> in them, leaving me with the plain codes on their own

do you want to see the ones with the symbols or without?

> end up just deleting the # - * ones, and then not saving the database as I
> would loose all the
> other codes.

Are you trying to delete one set or the other from the table or just
not view them?

Reply to this Message

Noddie - 16 Mar 2007 07:52 GMT

Hi and thankyou for taking the time to answer my email.
I am trying to filter 'out' all the records which have #, *, or - in them
and only leave
the records which do no have this in them.
Does that make sense?

I want to see only the ones 'without' the symbols.
Thanks heaps for your help.
Regards
Nod

> Hope this makes sense....

Not really. When you say

> I need to filter out all the codes that do not have
> -
> *
> #
> in them, leaving me with the plain codes on their own

do you want to see the ones with the symbols or without?

> end up just deleting the # - * ones, and then not saving the database as I
> would loose all the
> other codes.

Are you trying to delete one set or the other from the table or just
not view them?

Reply to this Message

Allen Browne - 16 Mar 2007 08:09 GMT

To filter out the records where Field1 contains a hash, dash, or star, use
this Criteria in your query:
Is Null OR Not Like "*[#-*]*"

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi and thankyou for taking the time to answer my email.
> I am trying to filter 'out' all the records which have #, *, or - in them
[quoted text clipped - 27 lines]
> Are you trying to delete one set or the other from the table or just
> not view them?

Reply to this Message

Noddie - 19 Mar 2007 04:07 GMT

Hi everyone
Many thanks for all your help with this matter, which i have been able to
sort out with your wonderful help.
Regards

Nod

To filter out the records where Field1 contains a hash, dash, or star, use
this Criteria in your query:
Is Null OR Not Like "*[#-*]*"

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Reply to this Message