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.
I want to print full address on 1 line.
Moderators: Moderators, Tech Support
-
- Posts: 320
- Joined: Sun Sep 28, 2003 5:37 pm
- Location: First Cutlerville Christian Reformed Church
- Contact:
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: I want to print full address on 1 line.
What is the actual expression that you have in that field?
it should look like this:
it should look like this:
Code: Select all
alltrim(address)+", "+alltrim(address2)+", "+alltrim(city)+", "+alltrim(state)+" "+alltrim(zip)
-
- 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.
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.
Thanks.
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: I want to print full address on 1 line.
Yes, that is what you would need to do on each of the fields. Glad to hear you got it working