How do u create criteria with a LIKE "xxx" or/and

S

stacy sin

I would like to find out how to use Query to filter out selective data like
start with an alphabet "d" and "e"? How do I define in my query?
 
R

RonaldoOneNil

In the criteria row of the relevant field column in your query put this (case
is irrelevant)

Like "d*" Or Like "e*"
 
K

Krzysztof Naworyta

stacy sin wrote:
| I would like to find out how to use Query to filter out selective
| data like start with an alphabet "d" and "e"? How do I define in my
| query?

Like "[de]*"
 

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

Top