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.

[lfpm062010]

Please see your post in "Query" section.

[ranman256]

You need the IF to determine if the [OrdDet] is null. You cant left on nulls.