Newbie open to suggestions

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I'm a newbie with ACCESS 2000 and I need to build a the following.
I'm capabale of putting together a database what I need some help is onthe
following.
I put together a list of clients in a datbase with all their informaiton.
What I need to be able to do is send reminders to my clients. The problem
that I have is that I need to send the following type of reminders 1 year,
30 days, 60 days, and 90 days. I have divided each client by the type
reminder they fall under. I need to 1. Automatically add the dates e.g. 30
days 01/02/2003 reminder would be 02/02/2003 after automatically adding the
30 daays. 2.Being able to run a query on any given date and have the records
show wich ones need reminders to be printed for that particular client.
What I had done before was to have a date and month field with the default
value for the month being =DATE("m",1,"06/26/2003") but the problem that i
ran into was that 07/26/2003 would come up no matter what the date field
displayed. I was thinking of using EDATE but i need some type of example ow
this would be used. I would appreciate any help or opinions.

Thanks for your help

Richard
 
Access has a wizard to create different types of Databases. I suggest you
investigate them and look at their coding.
You an probably use one of them to do what you want with a little tweaking.
 
-----Original Message-----
Access has a wizard to create different types of Databases. I suggest you
investigate them and look at their coding.
You an probably use one of them to do what you want with a little tweaking.

automatically adding
the and have the
records some type of example
ow


.
If you add 1 month to any fixed date, you are always
Click to expand...
going to get the same result. So your arguments have to
be flexible: =DATe("m",x,y), where x is the number of
months and y is the starting date.

I hope you get the idea. Best of luck.
 
Richard,

I would add two fields to your client table: ReminderDays (set
field props. to number,interger) and LastReminded (set props to date).
In the ReminderDays, put in the length of the reminder, ie 30, 60, 90,
365. In the LastReminded, enter the date that the last reminder was
sent.
Create a select query based on this table. Create an expression
that adds the date and days together ([LastReminded]+[ReminderDays]).
Enter <= Date() in the criteria section under this expression. This
will limit the records to only those before or on the current date.
Now create an update query based on the table. Again set up the
expression and criteria as you did in the last query. In the "update
to" section under the LastUpdated Field, enter Date(). When executed,
this will replace the date entered in the LastUpdated field (on those
records who are past or at the late point) with the current date (when
you ran the query).

Hope this helps,
GH
 
Back
Top