Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenate (How do you combine two fields into one?)

Status
Not open for further replies.
jmlbones

jmlbones

Technical User
Joined
Jul 16, 2001
Messages
13
Location
US
How can I combine data that is in two fields into one? I have to create one Name field from the First Name field and the Last Name field. Thanks.
 
Sort by date Sort by votes
FirstName & " " & LastName

Joe Miller
joe.miller@flotech.net
 
Upvote 0 Downvote
Thanks. Got it to work.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
863
mikrom
mikrom
mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
590
mhshane
mhshane
serino
  • Locked
  • Question Question
Find a number between two sets of numbers.
Replies
2
Views
1K
serino
serino
Wolfdzn
  • Locked
  • Question Question
Join two seperate SQL into one
Replies
6
Views
841
dhookom
dhookom
TrekBiker
  • Locked
  • Question Question
Use two sorts in query
Replies
7
Views
688
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top