HELP---Report 2.5

From: Andrew M. Balshem <am_balshem_at_fccc.edu>
Date: 1997/07/01
Message-ID: <33b91213.21464744@news.services.fccc.edu>#1/1

I would like to produce form letters such that if a person has a value for an "address2" field then the field would be displayed - otherwise it would not and we would not be left with a gap (a null line) in our report. For example:

Record 1

---

 		1313 Mockingbird Lane
		MonStars Apts.  -  Apt 1C
		Hollywood, CA 98989

Dear Herman:

---

Record 2

---

		1234 Fifth Street
		Anytown, PA 898989

Dear John:

---

Both record 1 and 2 are in a demographics table but record 1 has a value in address2 while record 2 does not. I can easily make record 2's letter look like the following:

Person 2

---

                  1234 Fifth Street

                Anytown, PA 898989

Dear sir:

---

but this looks sloppy. I could also build 2 reports - one for records with and another for records without a value in address2. However, I believe that I can accomplish what I want with a trigger on address2 whereby we could hide the null address2 line and print record 2 as I did in the first example of record 2.

Would someone e-mail an example or, at least, the steps in doing the above? Received on Tue Jul 01 1997 - 00:00:00 CDT