Supressing varying number of rows for each recipient

A

Albert

I am using Access as my data source.
The project is a debt collection letter merge.
Each recipent has a different number of items due.
The relevant part of the record layout is as follows:
[Desc_1]; [Amt_1] [Desc_2]; [Amt_2]....[Desc_n]; [Amt_n]
The Description field is always NOT NULL; however, the Amount field may be
null.
If the Amount field is null, how do I supress it and the corrresponding
Description?

Thanks,
 
D

Doug Robbins

Use an If...then...Else field construction to check the amount fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
A

Albert

Hi Doug: Thanks for the reply; however, how does If Then Else apply to merge
fields? I have only seen it used to insert messages as Word Fields. Please
post a brief example of your solution. Thanks very much.
--
Albert Chen


Doug Robbins said:
Use an If...then...Else field construction to check the amount fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
Albert said:
I am using Access as my data source.
The project is a debt collection letter merge.
Each recipent has a different number of items due.
The relevant part of the record layout is as follows:
[Desc_1]; [Amt_1] [Desc_2]; [Amt_2]....[Desc_n]; [Amt_n]
The Description field is always NOT NULL; however, the Amount field may be
null.
If the Amount field is null, how do I supress it and the corrresponding
Description?

Thanks,
Click to expand...
Click to expand...
 
G

Graham Mayor

{IF {Mergefield Amt_1] <> "" "{Mergefield Desc_1} {Mergefield Amt_1}
"}etc

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Hi Doug: Thanks for the reply; however, how does If Then Else apply
to merge fields? I have only seen it used to insert messages as Word
Fields. Please post a brief example of your solution. Thanks very
much.
Use an If...then...Else field construction to check the amount
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
Albert said:
I am using Access as my data source.
The project is a debt collection letter merge.
Each recipient has a different number of items due.
The relevant part of the record layout is as follows:
[Desc_1]; [Amt_1] [Desc_2]; [Amt_2]....[Desc_n]; [Amt_n]
The Description field is always NOT NULL; however, the Amount field
may be null.
If the Amount field is null, how do I supress it and the
corrresponding Description?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
A

Albert

Thank you.
--
Albert Chen


Graham Mayor said:
{IF {Mergefield Amt_1] <> "" "{Mergefield Desc_1} {Mergefield Amt_1}
"}etc

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Hi Doug: Thanks for the reply; however, how does If Then Else apply
to merge fields? I have only seen it used to insert messages as Word
Fields. Please post a brief example of your solution. Thanks very
much.
Use an If...then...Else field construction to check the amount
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
I am using Access as my data source.
The project is a debt collection letter merge.
Each recipient has a different number of items due.
The relevant part of the record layout is as follows:
[Desc_1]; [Amt_1] [Desc_2]; [Amt_2]....[Desc_n]; [Amt_n]
The Description field is always NOT NULL; however, the Amount field
may be null.
If the Amount field is null, how do I supress it and the
corrresponding Description?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
A

Albert

I must be missing something.
The following is displayed in the body of my letter:

{IF 10.00 < > "" Late Payment Penalty 10.00 }
{IF < > "" Interest Charge }

So the test is not being performed because it is just merging the Amount
field twice.
Please help me resolve this. Thanks again.
--
Albert Chen


Graham Mayor said:
{IF {Mergefield Amt_1] <> "" "{Mergefield Desc_1} {Mergefield Amt_1}
"}etc

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Hi Doug: Thanks for the reply; however, how does If Then Else apply
to merge fields? I have only seen it used to insert messages as Word
Fields. Please post a brief example of your solution. Thanks very
much.
Use an If...then...Else field construction to check the amount
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
I am using Access as my data source.
The project is a debt collection letter merge.
Each recipient has a different number of items due.
The relevant part of the record layout is as follows:
[Desc_1]; [Amt_1] [Desc_2]; [Amt_2]....[Desc_n]; [Amt_n]
The Description field is always NOT NULL; however, the Amount field
may be null.
If the Amount field is null, how do I supress it and the
corrresponding Description?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
G

Graham Mayor

Did you insert the field boundaries with CTRL+F9?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
I must be missing something.
The following is displayed in the body of my letter:

{IF 10.00 < > "" Late Payment Penalty 10.00 }
{IF < > "" Interest Charge }

So the test is not being performed because it is just merging the
Amount field twice.
Please help me resolve this. Thanks again.
{IF {Mergefield Amt_1] <> "" "{Mergefield Desc_1} {Mergefield Amt_1}
"}etc

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Hi Doug: Thanks for the reply; however, how does If Then Else apply
to merge fields? I have only seen it used to insert messages as
Word Fields. Please post a brief example of your solution. Thanks
very much.

Use an If...then...Else field construction to check the amount
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP
I am using Access as my data source.
The project is a debt collection letter merge.
Each recipient has a different number of items due.
The relevant part of the record layout is as follows:
[Desc_1]; [Amt_1] [Desc_2]; [Amt_2]....[Desc_n]; [Amt_n]
The Description field is always NOT NULL; however, the Amount
field may be null.
If the Amount field is null, how do I supress it and the
corrresponding Description?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
A

Albert

No. I will try it that way. Thanks.
--
Albert Chen


Graham Mayor said:
Did you insert the field boundaries with CTRL+F9?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
I must be missing something.
The following is displayed in the body of my letter:

{IF 10.00 < > "" Late Payment Penalty 10.00 }
{IF < > "" Interest Charge }

So the test is not being performed because it is just merging the
Amount field twice.
Please help me resolve this. Thanks again.
{IF {Mergefield Amt_1] <> "" "{Mergefield Desc_1} {Mergefield Amt_1}
"}etc

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Albert wrote:
Hi Doug: Thanks for the reply; however, how does If Then Else apply
to merge fields? I have only seen it used to insert messages as
Word Fields. Please post a brief example of your solution. Thanks
very much.

Use an If...then...Else field construction to check the amount
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP
I am using Access as my data source.
The project is a debt collection letter merge.
Each recipient has a different number of items due.
The relevant part of the record layout is as follows:
[Desc_1]; [Amt_1] [Desc_2]; [Amt_2]....[Desc_n]; [Amt_n]
The Description field is always NOT NULL; however, the Amount
field may be null.
If the Amount field is null, how do I supress it and the
corrresponding Description?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Query Criteria is lost in Recipients list in Mail Merge Word 2003 7
How to do merge with varying fields in each record? 2
Distinct rows 2
Merge w/varying amount of rows to repeat for each company 1
Performing expression on all (varying number of) fields 3
Repositioning columns of a data source field within the "Edit Recipient List" dialog box within the 1
Multiple Transactions per letter 1

Top