50+ Or Criteria is there a better way?

[athyeh]

Hi Folks,



I am trying to find a long list of records with [LID] as the criteria. Is there anyway to augment this query:

SELECT [maintable].LID, [maintable].Operator, [maintable].Process, [maintable].[Shift Type], [maintable].Notes, [maintable].[Time Added]
FROM [maintable]
WHERE ((([maintable].LID)=123)) OR ((([maintable].LID)=456)) OR ((([maintable].LID)=789))

To something like this:

SELECT [maintable].LID, [maintable].Operator, [maintable].Process, [maintable].[Shift Type], [maintable].Notes, [maintable].[Time Added]
FROM [maintable]
WHERE ((([maintable].LID)=
123
456
789
102
134
47
8
6
411
222
))

I am essentially looking for a more elegant/less painful way to query multiple OR Criteria?

Thanks!

[June7]

Try:

WHERE [maintable].LID IN (123, 456, 789)

Filter a form or report instead of directly in query:

http://allenbrowne.com/ser-50.html

[athyeh]

Perfect and as always thank you.

I know this is an Access forum but I think you probably know the answer to this as well.

In Excel,

Is there a way to bring several hundred rows of cells into one cell i.e.

=$A$1&", "&A2&", "&A3&", "&A4&", "&A5&", "&A6&", "&A7&", "&A67&", "&A68

But NOT manually typing out each cell value?

I tried something like $A$1&", "$A2&":"&A67&", "&A68 but no dice....

[June7]

Use VBA (called macros in Excel)?

What does the & mean in that usage?

[athyeh]

It's a form of Concatenate function, found a great resource about concatenating ranges of cells here:

http://excel.tips.net/T003062_Concat..._of_Cells.html

Thread solved.

Thank you for your replies.

[June7]

Yep - there's a LOT of functions in Excel I am not familiar with. Thanks for sharing solution.