Function to add up three variables and compare to another variable? How?

C

Crispywafers

Hi,

Can someone just tell me if it's possible to create a procedure that
would add up three variables and compare to another variable... and
add the difference or subtract?

We split our tuition into 3 equal payments. Due to rounding sometimes
we manually have to add a dollar or subtract a dollar to the last
tuition payment so that the three tuition payments equal the total
tuition payment.

Because we are trying to use access now to print and track our tuition
payments... I need a way to do this in the VB calculation for the last
trimester payment.

Help?
 
D

doco

Public Function getLastTrimester(cTotalDue As Currency, cCurrentPayments As
Currency) AS Currency
getLastTrimester = cTotalDue - cCurrentPayments
End Function

This is far too simple so I suppose I do not understand your question
entirely...

doco
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top