Error in Access query

[msaccessdev]

Hi There,

I am trying to join 2 tables based on the Employee ID and pulling out order name details. I have written a query and with in the query i have written a function something like this

OrdDetails: Left([OrdDet],InStr([OrdDet]," ")-1))

and it is running fine for the records that are matching in the tables. If there is no record in the first table then this expression throwing an error "#Error".

please advice.

[hapm]

OrdDet is from the first table? Is it an outer join query? Please provide the full query. Here is a first guess for the case when you answer the to questions with yes: OrdDetails: IIf(IsNull([OrdDet];Null;Left([OrdDet],InStr([OrdDet]," ")-1)))