Name Concatenate

[jjacob]

I'm trying to concatenate a name, but it's not coming out like I want it

Formula
Name: [dbo_Pr_EmpDemo_T]![chrFirstName] & " " &
[dbo_Pr_EmpDemo_T]![chrLastName]

Result
Julie Jacob

All of the names are set apart like this. The table comes from my payroll
data system linked into access. Could the parameters set in the table for
these fields have anything to do with the unusual result? TIA!

 

[Duane Hookom]

Try:
FullName: Trim([dbo_Pr_EmpDemo_T]![chrFirstName]) & " " &
Trim([dbo_Pr_EmpDemo_T]![chrLastName])

 

[jjacob]

Thanks Duane that did the trick!

Try:
FullName: Trim([dbo_Pr_EmpDemo_T]![chrFirstName]) & " " &
Trim([dbo_Pr_EmpDemo_T]![chrLastName])

--
Duane Hookom
MS Access MVP

I'm trying to concatenate a name, but it's not coming out like I want it

Formula
Name: [dbo_Pr_EmpDemo_T]![chrFirstName] & " " &
[dbo_Pr_EmpDemo_T]![chrLastName]

Result
Julie Jacob

All of the names are set apart like this. The table comes from my payroll
data system linked into access. Could the parameters set in the table for
these fields have anything to do with the unusual result? TIA!