Query and Arrays 1

[Spyrios]

Can I use an array in an Access query? I have a query right now that works, but it's growing way to large and it won't be easily managed the way I have it. This is what I have:

Basic: (select count(SalesType) from LocalSales where SalesType = 1 OR SalesType = 101 OR SalesType = 201) etc. etc.

That works, but I have so many options there it could get messy. What I want to do is something like this:

BasicSELECT COUNT(SalesType) FROM LocalSales WHERE SalesType = (1,101,201))

Any ideas?

 

[BNPMike]

Use IN as in IN (1,101,201). The contents of the IN can of course be another select.

 

[Spyrios]

AWESOME. Thanks, you just saved me a ton of trouble! If I could give 2 stars I would!

 

[BNPMike]

You're welcome.