More than one item in a field...

[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

 

[Hypernoodle]

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)

 

[otis1969]

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.

 

[otis1969]

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

 

[WayneRyan]

Otis,

Change your query.

Add a new field:

NewName: LastName & ", " & FirstName

Then just use NewName in your report.

Wayne

 

[otis1969]

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