How do you concatenate two fields in a report?

I

Iram

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



Thanks.
Iram/mcp
 
J

John Spencer

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
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Access 2002 change report header text 0
How to implement two shifts per day with multiple teams 0
=Count([Category] if it is equal to 'Task ID'"), how do I fix thi 4
Adding Totals on a report 2
Insert Multiple Fields without Dialog closing between each... 0
Creating relationships 0
MS Project Center-Autolink column fields 0

Top