How query mutiple entities within a single column?

[Vexorg]

Hello, i know this is very simple but please bare with me.



tablename= pref

Email	TNID 	First 	Last
email1.com	1	John	Walk
email2.com	2	Tom	Morgan
email3.com	3	Beth	Ann
email4.com	4	Sally	Jones
email5.com	5	Martha	Johnson
email6.com	6	Jill	Smith
email6.com	7	Amanda	Soler
email7.com	8	Joe	Money

Lets say i wanted to use to query the following data using the "TNID" field and i wanted to search using THNID=1,2,3,4.

These would be the results:

Email	TNID 	First 	Last
email1.com	1	John	Walk
email2.com	2	Tom	Morgan
email3.com	3	Beth	Ann
email4.com	4	Sally	Jones

How would i create a query to do this in acess? I understand its similar to this but im not sure the exact way to do it in access...

select email,tnid,first,last
from pref
where tnid like 1,2,3,4

Help!

[pbaldy]

Two ways

where tnid In(1,2,3,4)

where tnid = 1 OR tnid = 2 OR tnid = 3 OR tnid = 4

[ajetrumpet]

Paul,

is there some 'short' documentation on that usage of the Subquery? I've only used it in the full context (select...). If there are other shortcuts like that, is there a site that explains?

[pbaldy]

I'm not clear what you mean, as there is no subquery. I just posted the WHERE clause; the rest would still need to be there:

select email,tnid,first,last
from pref
where tnid In(1,2,3,4)

[ajetrumpet]

I'm not clear what you mean, as there is no subquery. I just posted the WHERE clause; the rest would still need to be there:

select email,tnid,first,last
from pref
where tnid In(1,2,3,4)

you used ''IN()'' paul. that's what I meant. it is not a subquery per-se, but it is almost the same concept.

[Vexorg]

Two ways

where tnid In(1,2,3,4)

where tnid = 1 OR tnid = 2 OR tnid = 3 OR tnid = 4

What if i have a list of like 300 items, that are in an excel column, how can i do this so it dont have to manually type this stuff. My guess is just running a function to consolidate the cells.

[weekend00]

where tind betwee 1 and 300

[pbaldy]

Ah, a moving target. If the Excel file is linked to the Access db, you should be able to join the Excel "table" to the Access table in your query and restrict the items returned to those in the Excel file:

SELECT...
FROM AccessTable INNER JOIN ExcelTable ON AccessTable.FieldName = ExcelTable.FieldName