Concatenate

[firebott]

I have a report that is ODBC linked to an access database. Within the report I need to concatenate the LN (Last name) and FN (First name). This is not something that I have had to do before and am struggleing to make it work. Can anyone help me?

[jggtz]

Create a New formula field and place it in the desired report section

{YourTable.LastName} + " " + {YourTable.FirstName}

[firebott]

Thanks. I could swear that I did that code and it kept giving me an error. Maybe I had an extra space in there that I couldn't see. But that worked and I appreciate your help.