Using 'Like xxx' as criteria in a query

A

Artie

I need help returning records that either begin with a
certain text string or exclude records that begin with a
certain text string.

I have a query with 30,000 records. Our company appears
as one of the records. I want to exlude all records that
have 'Ren' in a certain field.

Thanks for any help!
 
K

Ken Snell

Like "Ren*"

Above will return all records that have a value beginning with Ren.



Not Like "Ren*"

Above will return all records that don't have a value beginning with Ren.
 

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

QBF & Query Malfunction 0
Query criteria - exclude data and return all records if null 3
query to show where no data in a stated column 0
Copy previous record into form field 0
How can the font and size of (all) citation numbers be altered? 1
Changing query criteria to supply a form 3
Integers behaving like strings 5
Using Variable as criteria 4

Top