Merge with word date manipulation code

[Colleen]

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

 

[John Beschler]

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