Query to Filter for Multiple Items

[carl]

My records look like this.

Record ID Code Count
1 ABC 2
2 EFG 5
3 HIJ 7
4 KLM 9
5 NOP 10
6 QRS 6

Is ther a way to query the data for a list of items ? For example, if my
list include is:

ABC
EFG
HIJ

Can a query return:

Record ID Code Count
1 ABC 2
2 EFG 5
3 HIJ 7


I need to do this on a large scale - the list would have around 2000 items
so doing it 1 at a time has been taking too long.

Thank you in advance.

 

[Ofer Cohen]

I'm not sure if that what you are looking for, but try this

Select * From TableName Where

 In ("ABC","EFG","HIJ")

 

[Casey via AccessMonster.com]

Dear Carl:

You can try this:
SELECT ID, Code, Count
FROM (tablename)
WHERE code IN ('ABC', 'EFG', 'HIJ');

Just change the part after the IN for any different queries on this.
Let me know if this helps!

 

[carl]

Thank you.

Is there a limit on how many items I can place in this list ?

 

[Casey via AccessMonster.com]

Dear Carl:

Not to my knowledge there is not.

Thank you.

Is there a limit on how many items I can place in this list ?

Dear Carl:

[quoted text clipped - 34 lines]

 

[John Spencer]

Yes, there is a limit. I think you will run into a problem when you exceed 1024 characters.

A better way to handle this is to use a table to hold the list of items you want
and populate the table. Once you have the table populated you can join to the table.

SELECT ID, Code, Count
FROM [Name of your current table] INNER JOIN [Name of list items]