Not like Query??

K

Keith

How do I do a not like Query? I have a Credit Card Stat
feild that is used to show approval. If the card is
approved it has a number, If not approved it
has "Decline" or "Decl-Dup".

Any help would be great!!
 
R

Rick Brandt

Keith said:
How do I do a not like Query? I have a Credit Card Stat
feild that is used to show approval. If the card is
approved it has a number, If not approved it
has "Decline" or "Decl-Dup".
Click to expand...

So what records do you want included in the query?
 
K

Keith

Good point!! I would like to see all the records that do
not have "Decline" or "Decl-Dup".

Sorry about that!!!:)
 
R

Rick Brandt

Keith said:
Good point!! I would like to see all the records that do
not have "Decline" or "Decl-Dup".

Sorry about that!!!:)
Click to expand...

WHERE [Credit Card Stat] Not Like "Decl*"
 
Top