How do I query data using the Like operator, to search for a cert.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to use the Like operator to search through records, and return data in
the query that have the word "visual" in the title. How do i set this up?
 
In the criteria for your query, put

Like "*visual*"

If you're using ADO, the wildcard character will be %, not *, so you'll need

Like "%visual%"
 
how do i limit the criteria by using an OR, if i want titles that start with
an S or have the word visual in them?? im putting it like ="s" OR "*visual*",
but it wont return the titles that start with an S. The other one worked
like a charm!!
Thanks, Christen
 
You must log in or register to reply here.

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

Windows XP Vulnerabilities 1
Searching Multiple Fields in a query 4
How do I create a search form using a query (not using filters) 3
Using "like" query from and external link to Access 1
Date search query 0
Run-time error 80040e14 (Missing Operator) in '% ... Writer's Choice .... %" 2
how do i use the in operator to sort by type? 2
Query Parameter using multiple options 0

Back
Top