Transfer Credit Calculations

[HVVA]

I'm supposed to create a calculated field named TuitionPayments that determines tuition paid in three installments. I have to use the PMT function and replace the rate argument with 0.025/3, the num_periods argument with 3, and the present_value argument with the TuitionDue. Use 0 for the future_value and type arguments.



Can someone please help me?

[June7]

In a cell on the Fields row of query builder: Pmt(0.025/3, 3, [TuitionDue], 0, 0)

There is no Type argument but there is a Due argument.

[HVVA]

What about when I only have the name of the cell (LostCredits) and it asks to create a function that subtracts CreditsTransferred from CreditsEarned.

How do I set up this equation in the builder?

[June7]

I don't know your db so can't be sure but I will guess need to do some aggregate queries.

This is homework? Does the assignment specifically require VBA function? Perhaps you should get instructor to clarify.