| form letter [message #151414] |
Wed, 14 December 2005 14:51  |
oraanu
Messages: 22
Registered: September 2005
Location: Boston
|
Junior Member |
|
|
Hi All,
I am creating a form letter.in the boiler text i should decode the correct phone number where number is like 207 822 abcd depending on the region.
i am using the following query to find the region.
select distinct pxa.assoc_id ,a.assoc_name "Region"
from people_x_association pxa,
association a
where a.assoc_id=pxa.assoc_id
and a.assoc_name like 'REG%'
i need to Place the correct phone number on the report as listed below;
Region 1 Childrens 822-0146
Region 2 Childrens 287-4057
Region 3 Childrens 561-5003
Can anyone help me how to do this.i need it very urgent.
Thanks,
Anu
|
|
|
|
| Re: form letter [message #151821 is a reply to message #151414] |
Mon, 19 December 2005 06:29  |
orahugo
Messages: 32
Registered: October 2005
Location: England
|
Member |
|
|
You'll need to write a Program Unit that contains a series of IF statements where you return a parameter based upon the value of the region.
Then you'd add this to the original text in the boilerplate.
Ie. 0202 345 &:code
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
