I am currently creating a report that shows the last name and first name of fishermen. In the table the fields are LastName and FirstName.

On the report I would like to show the name kind of like this: Otis, Thehumble.

Right now they just show up with the last name, a big space, and then the first name. I guess ideally, I would like both names to show up in one field, but I don't know if that can be done

Originally posted by otis1969
I am currently creating a report that shows the last name and first name of fishermen. In the table the fields are LastName and FirstName.

On the report I would like to show the name kind of like this: Otis, Thehumble.

Right now they just show up with the last name, a big space, and then the first name. I guess ideally, I would like both names to show up in one field, but I don't know if that can be done

Change the textbox control source to:

=(LastName + ", " + FirstName)

I have tried that and now I get a bunch of #Error all over the report where the first name is. I also tried various combinations of that as well.

I still cannot get it working, someone please HELP!! :D

Otis,

Change your query.

Add a new field:

NewName: LastName & ", " & FirstName

Then just use NewName in your report.

Wayne

THANK YOU!!!!!!!!!!!!!!!!!