combining 2 fields into 1

  • Thread starter Thread starter Mandy
  • Start date Start date
M

Mandy

I would like to print out a report with people's names,
but they are in 2 columns. I would like 1 column on the
report so that I can center it on the paper better.
Here's what I have:

Last Name
First Name

I want it to be

First Name Last Name

I have tried putting the + in between but then the names
run together. I am making certificates and want to
center the name as one field on the paper. Thanks.
 
Thanks both Fons & Les. Yes, it did work.

Mandy
-----Original Message-----
Hi Mandy.
If you are combining the names in a query, simply type:
Fullname:[First Name] & " " & [Last Name]
on the report you would use a unbound textbox and enter
FullName.
If you do it directly in the report place an unbound
textbox on the report in design view and in the textbox
type:
=[First Name] & " " & [Last Name]
Hope this helps.
Fons
-----Original Message-----
I would like to print out a report with people's names,
but they are in 2 columns. I would like 1 column on the
report so that I can center it on the paper better.
Here's what I have:

Last Name
First Name

I want it to be

First Name Last Name

I have tried putting the + in between but then the names
run together. I am making certificates and want to
center the name as one field on the paper. Thanks.
.
Click to expand...
.
Click to expand...
 
Back
Top