Filtering in Access 97

N

Noddie

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
 
S

storrboy

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
Click to expand...

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.
Click to expand...

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

Noddie

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



storrboy said:
Hope this makes sense....
Click to expand...

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
Click to expand...

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.
Click to expand...

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

Allen Browne

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

Noddie

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 "*[#-*]*"
 
Top