Space betwen Name and Surname

[kuben]

Hi

I have two fields [Name] and [Surname]. What I insert this on a report
I would like the name and surname to be side-by-side without any extra
space between.

I don't know if this makes sense??

Kuben
South Africa

 

[Guest]

Create a field in the report and in the control source you can write
=[Name] & [SurName]

 

[fredg]

Hi

I have two fields [Name] and [Surname]. What I insert this on a report
I would like the name and surname to be side-by-side without any extra
space between.

I don't know if this makes sense??

Kuben
South Africa

Use an unbound control in the report.
Set it's Control Source to:
=[FirstName] & " " & [Surname]

Note 1: I assume you do want at least one space between the names.
Note 2: Name is a reserved Access/VBA/Jet word and should not be used
as a field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

 

[Guest]

Thanks Larry,
I didn't forget, I got confused because Kuben asked to have no extra space
between the two fields.
After Fred replied I realized my mistake.

Create a field in the report and in the control source you can write
=[Name] & [SurName]

Ofer, you forgot the space -- =[Name] & " " & [SurName]

I know you knew this and just typed too fast...

 

[Larry Linson]

Create a field in the report and in the control source you can write
=[Name] & [SurName]

Ofer, you forgot the space -- =[Name] & " " & [SurName]

I know you knew this and just typed too fast...