Converting SQL statement to VB for Microsoft Word usage

[barefoottraveler]

I am not a programming guru by any means. Now that I have said it:

I have a SQL statement I use in Crystal Reports that allows me to keep the address block togehter(no spaces) when there is no information populating the 'Careof' field. I need to reproduce this statement in a Microsoft Word mail merge document. I have no clue where to even begin.

Any assistance would be greatly appreciated.

Here is the SQL statement:

if not isnull({Tx_rrg_fulf_Query.BROK_CAREOF}) then
{Tx_rrg_fulf_Query.BROK_CAREOF}
Else
{Tx_rrg_fulf_Query.BROK_ADDR}

 

[SkipVought]

Hi,

In MailMerge there is a Control Field for If..Then..Else.

But I believe that no value will suppress the line feed without If..Then..Else. Try it.

Skip,

_[red][/red]