How can I create a space in the row field in a query to seperate .

N

Nathan Smith

I have created a query in Access and several fields for it. In one field I
combined the first and last name of a person, since they are seperated in the
table that I am using. However, when I run the query the two field are
combined together with no space between them. Since this is hard to read I
need to add a space inbetween the names. However, I cannot find out how to
do this. Please respond if you can help me with my situation. Thanks in
advance!
 
S

SteveS

Nathan Smith said:
I have created a query in Access and several fields for it. In one field I
combined the first and last name of a person, since they are seperated in the
table that I am using. However, when I run the query the two field are
combined together with no space between them. Since this is hard to read I
need to add a space inbetween the names. However, I cannot find out how to
do this. Please respond if you can help me with my situation. Thanks in
advance!
Click to expand...

Have you tried....

FullName: [FName] & " " & [LName]

or

FullName: [LName] & ", " & [FName]


replacing [LName] and [FName] with your field names.

HTH
 
Top