Hi - thank you for your help.
Not sure where the "trim" is but tried:
Left([client] & ",", Instr([client] & ",", ",") - 1)) AS LastName
Got error, "the expression has too many parenthesis"
Remove one and got "invalid syntax"
Added one and got "... function containing the wrong...