How do I filter text in a query??

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

Guest

I'm really stuck in the database that I have created. I need to be able to
have a filter for a text field (example: filtering by name) but I really
don't know how to do this. Simply filtering the table is not enough, seeing
as I need to have more then one filter going at the same time.

Can anyone give me a hand?
 
You use a query to do what you seek. Here is an example SQL statement
(generic) that will run a query that asks you to enter the first letters of
the text in the text field:

SELECT *
FROM TableName
WHERE [NameOfTextField] Like [Enter first few characters...] & "*";


Or, if you want to search for a text fragment within the text field:

SELECT *
FROM TableName
WHERE [NameOfTextField] Like "*" & [Enter some characters...] & "*";
 
Back
Top