concatenation

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

 

[Pete Duffy]

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.

 

[Linda]

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