#1. I have a payments schedule for customer #1.

I want to find the customers most recent payment date.
then I want to calulcate that.

#2. Example: date of payment less todays date = number of days.


Say I want to sent reminders out that are past due 45 days.
(I know I want to put the criteria to be "> 45". I am not a
programmer so need it to apply to a criteria in a query.

Thanks much.

direiter (AT) charter (DOT) net (di) wrote in message news:<9b1c868a.0404292001.1dab0d0c (AT) posting (DOT) google.com>...
Hello,

Perhaps you can check into the DateDiff() Function and put
the following data into your query to display the total
days involved.

Example:

DaysElapsed: DateDiff("y", [txtRecentPayment], Date())

txtRecentPayment is the field which has your required
information, and the Date() function is the current
computer date on your system. Both are compared which
result in the total number of Days different.

Regards,

Ray