How do you concatenate two fields in a report?

  • Thread starter Thread starter Iram
  • Start date Start date
I

Iram

Hello.
How do you concatenate two fields in a report?
Please describe in detail. I am new.



Thanks.
Iram/mcp
 
In a control on a report, set the control's source to
=[FirstField] & " " & [SecondField]
Make sure that the name of the control is NOT the same as the name of
one of the fields in the report.


In the query source of the report
Field: NewFieldName: [FirstField] & " " & [SecondField]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top