RE: Merge with word date manipulation code

From: John Beschler (JohnBeschler_at_discussions.microsoft.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 16:57:01 -0700

Colleen,

There are some basic logic type function included in Word when you have a
mail merge main document.

To access them, you need to find the InsertWordField toolbat button. On
that button, one of the Word fields is "If...Then...Else". You should be
able to use that to compare fields in your record and control your oupput to
the document accordingly. It's not exactively intuitive, but I was able to
make it work in the simplistic testing I did.

If you have problems, reply to me in the NG and I will try to help you
further.

John

"Colleen" wrote:

> I have a word file that merges with Access. Parameters
> are asked for for SSN# and particular dates. At the top
> of the form I have a [BegDate] field which is calculated
> in the query and a [PPIDate] field which I need to add a
> [ProbDate] field.
>
> In my query I have added a column to give me a begin
> date. I originally had a formula in it to calculate 364
> days prior to my [PPIDate].
>
> What I need is for this date to give me a calculation not
> only on the PPIDate but also for a [ProbDate] which would
> only be 182 days prior. And some way for it to know which
> one it is.
>
> I thought of putting in another column with an [Effective
> Date] and have it somehow look in each [*date]field and
> select the one date that matches and do the correct
> calculation and place the correct dates on my word form.
>
> If I am asking too much and should just make two sets of
> the word form just let me know. (I hope not since there
> are 24 of the documents)
>
> Colleen
>