Hi,

I have this query in the crystal report

SELECT tblEmployees.iEmployeeNum, tblEmployees.tLastName, tblEmployees.tFirstName
FROM tblEmployees
WHERE tblEmployees.iEmployeeNum IN ({?empNum})

?empNum is parameter define to allow multiple values (numbers)

When I create this, a form is shown to enter values (probably to test this query).
If I enter one value for ?empNum, everything is fine, but if I try to enter 2 or more integers there is error saying
---
Failed to retrive data from the database.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for SQL Server
Discription: Incorrect syntax near ','
SQL State 42000
Native Error: [Database Vendor Code: 102]
---

Please help. Thanks.