multiple queries 1

[kennetha]

I have created a query but I need to enter multiple criteria. I used "Between and " but it's not always usefull. I would like to enter for example 112,113,116,117 & 120.
Can someone help please
Thanks
Kenneth.

 

[HarleyQuinn]

Have a look at the IN. E.g.

SELECT * 
FROM YOURTABLE 
WHERE NAME [red]IN[/red] ('Andrew','John','Steve')

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[HarleyQuinn]

Have a look at IN. E.g.

SELECT * 
FROM YOURTABLE 
WHERE NAME [red]IN[/red] ('Andrew','John','Steve')

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[HarleyQuinn]

Oops. Sorry for the double post. Hit submit by accident.

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[kennetha]

Can I enter data in a table and ref to it instead of SELECT *
FROM YOURTABLE
WHERE NAME IN ('Andrew','John','Steve')

Thanks Kenneth

 

[HarleyQuinn]

If you wish to do it like that it might be easier to use:

SELECT YOURTABLE.NAME
FROM YOURTABLE,YOURTABLE_OF_NAMES
WHERE YOURTABLE.NAME = YOURTABLE_OF_NAMES.NAMES

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.