I want to print full address on 1 line.

Moderators: Moderators, Tech Support

Post Reply
John Dykema
Posts: 320
Joined: Sun Sep 28, 2003 5:37 pm
Location: First Cutlerville Christian Reformed Church
Contact:

I want to print full address on 1 line.

Post by John Dykema »

I want to print addresses on the same line as the name. In the Edit Output Fields I have:
... Address Line 1, address line2, City + state + zip/postal
such as ..... 1534 Elm St, Manor Rm 102, Anywhere WI 76543

I'm trying to use the ALLTRIM command but the following spaces are not getting trimmed.
Please advise.

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: I want to print full address on 1 line.

Post by Zorak »

What is the actual expression that you have in that field?

it should look like this:

Code: Select all

alltrim(address)+", "+alltrim(address2)+", "+alltrim(city)+", "+alltrim(state)+" "+alltrim(zip)

John Dykema
Posts: 320
Joined: Sun Sep 28, 2003 5:37 pm
Location: First Cutlerville Christian Reformed Church
Contact:

Re: I want to print full address on 1 line.

Post by John Dykema »

Zorak, thanks. Using your example I get ,, whenever there is a missing field in the address. So what I did was created: IIF( statements to check for NOT EMPTY on each field.
Thanks.

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: I want to print full address on 1 line.

Post by Zorak »

Yes, that is what you would need to do on each of the fields. Glad to hear you got it working

Post Reply