L
Lhsmith
I am a new user creating a databse in Access 2003 to do some prospecting.
Does anyone have a query or macro that will generate a date based upon
another date. I receive a list of new contacts every day. I would like to
send a letter to those contacts 5 times between the day I receive the list
and a date that is usually five or six weeks in the future. I need a query
or macro that generates a new mail date based upon the date that I enter the
information and the that date in the future.
My table for dates is Dates and contains the following fields:
List_date
Id_Num (PK)
Critical_date
What I would like to see happen is, for example, if I receive and enter a
list on 2/1 (list date) and crticial_date is 2/26 then there are 25 days
between list_date and critical_date. If my plan is to send five letters
then, 25 days/5 letters would be a letter on 2/1, 2/6, 2/11, 2/16, 2/21.
Any suggestions?
Does anyone have a query or macro that will generate a date based upon
another date. I receive a list of new contacts every day. I would like to
send a letter to those contacts 5 times between the day I receive the list
and a date that is usually five or six weeks in the future. I need a query
or macro that generates a new mail date based upon the date that I enter the
information and the that date in the future.
My table for dates is Dates and contains the following fields:
List_date
Id_Num (PK)
Critical_date
What I would like to see happen is, for example, if I receive and enter a
list on 2/1 (list date) and crticial_date is 2/26 then there are 25 days
between list_date and critical_date. If my plan is to send five letters
then, 25 days/5 letters would be a letter on 2/1, 2/6, 2/11, 2/16, 2/21.
Any suggestions?