concatenation

  • Thread starter Thread starter Keith Harden
  • Start date Start date
K

Keith Harden

I am trying to combine first and last name from two separate fields. These
fields are in a query. Here is what I have been doing. What is wrong?
[first name]&""&[lastname]
 
Not sure what your query looks like, in the field name of the query type
FullName: [first name]&""&[lastname]

I suspect right now you may be getting a request for info screen.
 
There is a space between first name and no space in lastname. The fields in
the brackets must be exactly the same as the fields your are joining
together. You probably want a space between the " marks too.

Linda
 
Back
Top