Name Concatenate

G

Guest

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!
 
D

Duane Hookom

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

Guest

Thanks Duane that did the trick!

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

--
Duane Hookom
MS Access MVP


jjacob said:
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!
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate on a report 6
Excel Concatenate Form Name to Parse for function 1
Trouble concatenating using tblName.FieldName 8
Concatenating - Q? for D. Hookom 2
Lookup against concatenated source value 2
Concatenate a list of names from same field 8
Concatenate not working 2
How to Add and Concatenate When > Zero 6

Top