Combining Name Fields in Query

[tyemm]

I have not yet been able to combine or concatenate name parts in a query!
I have Last, First and MI as fields in a table NAME that I inherited. I want to create a fourth field in the form Last First MI, with spaces between First and MI, if MI exists, and no space after First, if MI doesn't exist (and space between Last and First, of course). I need help combining in these two different situations: where MI exsits and where it doesn't!

 

[rac2]

The SQL to obtain the name would be like this.

SELECT Last & ", " & First & IIf( MI IS NOT NULL, " " & MI, "")
FROM MyTable

 

[tyemm]

I knew it was that simple!
Thanks--
Tom