How do I concantenate 2 fields

[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!

 

[Guest]

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]