Combine two columns of query not columns from table

[billybeer]

I have a query that can combine two columns from a table: Name for combining first and last names: [DFLNAME] & ", " & [DFFNAME]
However, my query makes some changes to the DFFNAME column from the table (chops off the middle name when included so now the column in the query for DFFNAME is Expr1: IIf(InStr([DFFNAME]," ")>0,Left([DFFNAME],InStr([DFFNAME]," ")-1),[DFFNAME])
I would like to combine the first name and last name columns that were returned in the query i.e. the first name without any middle names and last name. Can I do this in this query or can/must I do it later when doing a report based on this query. Thanks

[June7]

You can replace Expr1 with an alias name of your preference, such as: FName

Just create another field with that concatenates the calculated field with DFLNAME.

FullName: FName & DFLNAME

Or just concatenate DFLNAME with the expression and call the field FullName.

[JoeM]

Just substitute that calculation in where the field was, i.e.
[DFLNAME] & ", " & IIf(InStr([DFFNAME]," ")>0,Left([DFFNAME],InStr([DFFNAME]," ")-1),[DFFNAME])

[billybeer]

Works. Thanks again.