How do I create a field in the report that displays as First Name and Last name

[Asha]

I am creating a report. The report is based off of two
tables. Log Table and User table. The log table has a
userid field that is linked to the primary key of
User.UserID. I am trying to get the firstName + lastName
to display on the report. I can use a combo box, and link
it to the user table, but only the first name appears. I
can add two combo boxes to get both first name and last
name to appear, but they are incorrectly spaced, and it
looks really bad. I think you can probably do a text box,
and enter a formula to go pull from the user table first
name and last name, but I don't know how to do this. or
maybe you can do a formula on the two combo boxes to
eliminate white space...

Can someone please help.....

 

[Andy Williams]

Try,

=TRIM([firstName]) + " " + TRIM([lastName])

-Andy

 

[Rick Brandt]

I am creating a report. The report is based off of two
tables. Log Table and User table. The log table has a
userid field that is linked to the primary key of
User.UserID. I am trying to get the firstName + lastName
to display on the report. I can use a combo box, and link
it to the user table, but only the first name appears. I
can add two combo boxes to get both first name and last
name to appear, but they are incorrectly spaced, and it
looks really bad. I think you can probably do a text box,
and enter a formula to go pull from the user table first
name and last name, but I don't know how to do this. or
maybe you can do a formula on the two combo boxes to
eliminate white space...

Can someone please help.....

Use a TextBox with the ControlSource...

=[firstName] & " " & [lastName]

 

[JSand42737]

I am creating a report. The report is based off of two
tables. Log Table and User table. The log table has a
userid field that is linked to the primary key of
User.UserID. I am trying to get the firstName + lastName
to display on the report. I can use a combo box, and link
it to the user table, but only the first name appears. I
can add two combo boxes to get both first name and last
name to appear, but they are incorrectly spaced, and it
looks really bad. I think you can probably do a text box,
and enter a formula to go pull from the user table first
name and last name, but I don't know how to do this. or
maybe you can do a formula on the two combo boxes to
eliminate white space...

Can someone please help.....

Asha

Add a text box to the report. Set the ControlSource of this Text Box to:

=[FirstName] & " " & [LastName]

This will produce output like "Joe Bloggs".