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
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