How do I Combine Fields in the Report Designer?

[epalanb]

I know I have done this before, but I am trying to combine fields in the report designer. For Example I want City State and Zip all together. In the past I remember adding a field and having the option to add a custom field but now I do not see it. I did something like"

City1&", "&State1&" "&Zip1

I am using ACT! by Sage 2010 Version 12.1.181.0, Hot Fix 1

[Roy_Laudenslager]

That's the basic script that you would use with a custom field. Remember you need to add and hide the source fields for the script.

There is a third party book with comprehensive training information on the ACT! reports, here is the link.

https://www.packtpub.com/sage-act-2011-dashboard-and-report-cookbook/book

Full disclusure I wrote the reports chapters of the book.  The report chapters work for all version of the ACT! program since ACT! 2007.

[epalanb]

Thanks,

It sort of came back to me. It is like they describe how to eliminate spaces on labels. I had not done it for a few years so I couldn't remember, but now that you mention this I went back and found an old knowledgebase article on removing spaces from City - State - Zip on labels and I got it to work the way I want.