warning date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

dear sir /brother/sister
im having 3 date fields for an database of monthly recurringdeposit agent
which needs an warnig date over a query
DETAIL: field 1 custemer RD START DATE
FIELD 2 TENURE 5YEARS
QUERY01: MATURITY DATE =([STARTDATE]*(TERM*12))

NOW IWANT THE MONTHLY DUE DATE TO BE NOTIFIED
THATIS QRY([start date]+30)
but how to give every month warning if not paid by the custemer till end of
the term
kindly replay

balu
 
I can help you but I will need more detail. What defines the 30 days?
Calendar days (all 30 days) or only work days (Monday through Friday)? Also,
are you wanting the system to auto remind you of the recurrance of the
payment or is this just a simple query that will show the recurance of the
payment when the query is run?


Ruel
dear sir /brother/sister
im having 3 date fields for an database of monthly recurringdeposit agent
which needs an warnig date over a query
DETAIL: field 1 custemer RD START DATE
FIELD 2 TENURE 5YEARS
QUERY01: MATURITY DATE =([STARTDATE]*(TERM*12))

NOW IWANT THE MONTHLY DUE DATE TO BE NOTIFIED
THATIS QRY([start date]+30)
but how to give every month warning if not paid by the custemer till end of
the term
kindly replay

balu
 
dear ruel,
day is the due date of the calender day,for eg:RD start date is 2/01/07 the
next monyhly due date will be 2/2/07, & term is max duration of the scheme
i,e, for eg 5 years ,if for an RD agent of an bank have the 1000 rd custemers
recognised by their account number paid members account will be updated with
the monthly installment paid ,now if paid the next due date shuld be warned
immideatly /later
&(2) if un paid members are available the last due date was to be
notified
& it is better it shall be calculated by an query ,
thanking you
balu


Ruel via AccessMonster.com said:
I can help you but I will need more detail. What defines the 30 days?
Calendar days (all 30 days) or only work days (Monday through Friday)? Also,
are you wanting the system to auto remind you of the recurrance of the
payment or is this just a simple query that will show the recurance of the
payment when the query is run?


Ruel
dear sir /brother/sister
im having 3 date fields for an database of monthly recurringdeposit agent
which needs an warnig date over a query
DETAIL: field 1 custemer RD START DATE
FIELD 2 TENURE 5YEARS
QUERY01: MATURITY DATE =([STARTDATE]*(TERM*12))

NOW IWANT THE MONTHLY DUE DATE TO BE NOTIFIED
THATIS QRY([start date]+30)
but how to give every month warning if not paid by the custemer till end of
the term
kindly replay

balu
 
Zip me a copy of your .mdb file and I'll send it back with my take on what
you need.

Email: (e-mail address removed)





dear ruel,
day is the due date of the calender day,for eg:RD start date is 2/01/07 the
next monyhly due date will be 2/2/07, & term is max duration of the scheme
i,e, for eg 5 years ,if for an RD agent of an bank have the 1000 rd custemers
recognised by their account number paid members account will be updated with
the monthly installment paid ,now if paid the next due date shuld be warned
immideatly /later
&(2) if un paid members are available the last due date was to be
notified
& it is better it shall be calculated by an query ,
thanking you
balu
I can help you but I will need more detail. What defines the 30 days?
Calendar days (all 30 days) or only work days (Monday through Friday)? Also,
[quoted text clipped - 18 lines]
 
Back
Top