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

easy one, maybe

Status
Not open for further replies.
kwill

kwill

Technical User
Aug 15, 2001
49
US
can you concatenate two query fields into one form text box? Like first name & last name. thanks
 
Sort by date Sort by votes
= [MyTable].[FirstName] & " " & [MyTable].[LastName] Terry M. Hoey
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
786
atadbitslow
atadbitslow
JerryR
  • Locked
  • Question
Access 365 - Only allow one user to open 1
Replies
5
Views
404
JerryR
JerryR
Moss100
  • Locked
  • Question
Turn one to many relationship into single records 2
2
Replies
34
Views
1K
Moss100
Moss100
bigdavidt
  • Locked
  • Question
Error 3022 when navigating from one record to another record.
Replies
2
Views
220
bigdavidt
bigdavidt

Part and Inventory Search

Sponsor

Back
Top