Concatenation

[dave]

Hi

I'm new to Access but I am trying to do a report and having problems! I'm
sure there is a simple answer to it!

I have a table with First Name (FName) and Surname (SName) in separate
fields. When I do a report the names look bad because they are in two
separate columns. I want to concatenate the FName and SName fields into one
field on the report. I have had a play trying things like FName & " " &
SName but without success.

Any ideas?

Thanks

 

[JulieD]

Hi Dave

you're definitely on the right track ... i find it always easier to base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in, followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

 

[dave]

Thanks!

Hi Dave

you're definitely on the right track ... i find it always easier to base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

 

[JulieD]

you're welcome

Thanks!