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 Mike Lewis 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
Jul 16, 2001
13
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
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
505
serino
serino
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
168
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use two sorts in query 1
Replies
7
Views
144
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
150
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
423
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top