Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Calculating Total Amount of future payments based on an expiration date.

Avatar of brent9696
brent9696Flag for United States of America asked on
Microsoft Access
20 Comments1 Solution411 ViewsLast Modified:
I need to determine the total dollar amount of payments made from today to a contract expiration date.

The fields are as follows:

CTRCT_EXPIRATION_DATE

FEBRUARY_PMT

These are ongoing charges paid every month with no interest or increases involved.  Just need to find out (based on the February Payment amount how much we will pay out from February up until the expiration dates of the contract for each record.

Please help!  Need this ASAP for a meeting!

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Steve Bink
Commented:
This problem has been solved!
Unlock 1 Answer and 20 Comments.
See Answers