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*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Integrating information from Word to Excel (not mail merge) 1
IIF Statement not working as expected 3
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Query critieria to exclude 2 words 2
Timesheets not going to Approver 0
Chart For Hiring Plan 0
Making id cards 1

Top