Spacing in Customer's Name

K

KKash

I've written a query to pull from two separate fields (Last Name) (First
Name) into one field (First Name Last Name) However, I can't figure out how
to put the space between the First and Last Name. Is there a Symbol I'm
missing or something? Thanks!
 
F

fredg

I've written a query to pull from two separate fields (Last Name) (First
Name) into one field (First Name Last Name) However, I can't figure out how
to put the space between the First and Last Name. Is there a Symbol I'm
missing or something? Thanks!
Click to expand...

FullName:[FirstName] & " " & [LastName]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access to split First and Last name 0
Separating Last Name, First Name into Two Fields 4
can i separate a name field into 2 separate columns? 8
Trim trailing spaces for name field in query 4
Seperate First Name and Last Name 3
If statement in Update query 7
Sorting by Last Name and then First Name in the Same Field 2
Query that will look for duplicate in two tables. 3

Top