Access to word merge w/date manipulation

  • Thread starter Thread starter Colleen
  • Start date Start date
C

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
 
I would do the calculation in the query. You just need
to be clear in your own mind about the criteria for
choosing which date to use: show us that and I think
we could show you how to write the expression.

(david)
 
Back
Top