concatenate

[srideout2525]

My report is based on a query. Two fields, for example are, FName and LName or a Client. Instead of displaying them intwo text boxes, (because the spacing makes it look like a nightmare), I'd like to concatenate them together. I have had no trouble doing this it the values are pulled from a form, but I can't seem to get it when it pulls from a query. Is it possible? I must be just missing something simple.

Any help???

Thx

 

[Mile-O]

FullName: [Surname] & ", " & [Forename]


Or however you'd like to display them.

 

[AncientOne]

If your report is based on a query which includes FName and LName and you can see them both in the field list, you should experience no problems. But don't try to concatenate the fields into a Text box having either of these names as the original control source. Create a new text box on your report and enter the formula

= FName & " " & LName

 

[Mile-O]

Sorry, for some reason I thought I was in the Queries forum.