Where = Question

[viking79]

 Hi,

I want the report I'm working on to bring back info based on where an id equals either 1,2,or 11

When I put all three in the query, I get errors, Any suggestions?

 

Thanks

[cbarlow3]

Can you post your SQL query?  Can you post the error?  I don't even know the data type of ID or what syntax you used in your WHERE clause, but if I assume for the moment that id is an integer data type, I would think either of the following would work:

SELECT
  id, field2, field3
FROM
  recordName
WHERE
  id=1 OR id=2 OR id=11
 
or

SELECT
  id, field2, field3
FROM
  recordName
WHERE
  id IN (1, 2, 11)

Hope that helps.

Carl

[viking79]

 Thanks for your help, it happened to be an interger data type so the second one worked out just fine.

 

Thanks again :)