How do I concantenate 2 fields

  • Thread starter Thread starter Floridagal
  • Start date Start date
F

Floridagal

I am querying a table with the fields
1. First Name (John)
2. Last Name (Smith)

I want to combine the fields (John Smith), what function
do I use. In Excel, I use Concatenate, I don't see it in
Access.

TIA!
 
If you are using an unbound textbox on a form or report to
display the result, the contol source for the textbox
would be:

=[First Name] & " " & [Last Name]
 
Back
Top