concatenation

[Guest]

I have a field called UserName in a query, this is in the form of
Firstname.Surname, i have concatenated my FirstName and LastName together by
using:

UserName: [tbl_StaffDetails].[FirstName]&[tbl_StaffDetails].[LastName]

How do i get the . (dot) inbetween the firstname and lastname?

Any help again wopuld be appreciated

Martin

 

[Guest]

Hi Martin

[tbl_StaffDetails].[FirstName]&"."&[tbl_StaffDetails].[LastName]

 

[Rick Brandt]

I have a field called UserName in a query, this is in the form of
Firstname.Surname, i have concatenated my FirstName and LastName
together by using:

UserName: [tbl_StaffDetails].[FirstName]&[tbl_StaffDetails].[LastName]

How do i get the . (dot) inbetween the firstname and lastname?

Any help again wopuld be appreciated

Martin

UserName: [tbl_StaffDetails].[FirstName] & "." & [tbl_StaffDetails].[LastName]

 

[Guest]

Thanks for all the help guys, worked great!

I have a field called UserName in a query, this is in the form of
Firstname.Surname, i have concatenated my FirstName and LastName
together by using:

UserName: [tbl_StaffDetails].[FirstName]&[tbl_StaffDetails].[LastName]

How do i get the . (dot) inbetween the firstname and lastname?

Any help again wopuld be appreciated

Martin

UserName: [tbl_StaffDetails].[FirstName] & "." & [tbl_StaffDetails].[LastName]