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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help merging two fields

Status
Not open for further replies.
blopez

blopez

MIS
Mar 19, 2001
9
US
I am new to access and I have a question. How do you merge to fields - like merging a last name field with the first name field??
 
Sort by date Sort by votes
Just connect the fields with an &.

=[field1] & " " & [field2] Maq B-)
<insert witty signature here>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Question
switch between two open database
Replies
12
Views
545
Andrzejek
Andrzejek
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
697
dhookom
dhookom
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
311
atadbitslow
atadbitslow
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
128
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Can I map fields when connecting to SQL Server thru ODBC? 1
Replies
1
Views
85
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top