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

  • Thread starter Thread starter Asha
  • Start date Start date
A

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

Use a TextBox with the ControlSource...

=[firstName] & " " & [lastName]
 
"Asha" said:
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.....
Click to expand...

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".
 
Back
Top