#Error in the query expression

[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.

[lfpm062010]

Check the [OrdDet] and skip the left if it is null. Try this. (Code not tested)

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