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

  • Thread starter Thread starter stacy sin
  • Start date Start date
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?
 
In the criteria row of the relevant field column in your query put this (case
is irrelevant)

Like "d*" Or Like "e*"
 
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]*"
 
Back
Top