sql expression

[qlan]

Hello,

Below is my sql expression. However, it gives me this error message, "Error in compling SQL Expression:
Query Engine Error: DAO Error Code: 0xd1a
Source: DAO.Database
Description: At most one record can be returned by this subquery."

SELECT tblEmployees.EmployeeID
FROM tblEmployees
WHERE NOT EXISTS (SELECT tblLostTime.EmployeeID
FROM tblLostTime
WHERE tblEmployees.EmployeeID = tblLostTime.EmployeeID)

Would you please help what does this mean. Thanks so much.

 

[lbass]

A SQL expression cannot be used to return multiple records. Instead, place your query in a command object (database->database expert->your datasource->add command).

-LB