Keywords in queries

[TechnicalScott]

Hi all,

How do I make it so that my query can handle keywords ?
Eg - I have a field which contains - "paris, london". How do i get the query to pickup either one of those words from my input so that i can report on it?

Kindest Regards

Scott

 

[mp9]

Experiment with the LIKE operator:

SELECT * FROM tableNameHere WHERE fieldNameHere LIKE '*paris*';

SELECT * FROM tableNameHere WHERE fieldNameHere LIKE '*london*';

SELECT * FROM tableNameHere WHERE fieldNameHere LIKE '*paris*' OR fieldNameHere LIKE '*london*';

http://www22.brinkster.com/accessory/

 

[JerryKlmns]

Pick up sounds like... prompting?
Maybe a parameter query!

PARAMETERS [Enter city:] Text(255);
SELECT *
FROM tableNameHere
WHERE fieldNameHere LIKE [Enter city:] & '*';

 

[mp9]

Or to follow on from Jerry's post, to allow for the city name searched for not necessarily being at the start of the field...

PARAMETERS [Enter city:] Text(255);
SELECT * 
FROM tableNameHere 
WHERE fieldNameHere LIKE '*' & [Enter city:] & '*' ;

http://www22.brinkster.com/accessory/

 

[TechnicalScott]

prompting is right, is there a way to put a command in one of the query criteria boxes ?

Thank you for your help

 

[JerryKlmns]

TechnicalScott,

command is interpreted to what? Pls define

 

[TechnicalScott]

sorry - statement

 

[TechnicalScott]

so does this code go into the query or something else ?

 

[JerryKlmns]

Copy paste into the SQL View of a new query.
If you need extra criteria for the query, apply them accordingly after switching to design view.