Hello all! I have an Access Query syntax error as a result of formatting my Pmt function in a query that I cannot resolve. Specifically I am attempting to answer a question using the Pmt function for an assignment, and it is killing me that I cannot figure it out successfully.
The question is: Create another calculated field named TuitionPayments that uses the payment function and determines tuition paid in four installments. The student’s tuition payment and a 2.5% interest rate should be used in the function. Use 0 for the future_value and type arguments.
What I have inputted via the Expression Builder in the proper cell of the query is: TuitionPayments: «Expr» Pmt(.025, 4, [TuitionDue], 0, 0)
I am really wanting to learn! Am I way off base here? Should I have used brackets or parenthesis somewhere/somehow? Why is the error "The expression you entered contains invalid syntax" for what I inputted, when I followed the expression builder for both rate and num_periods (TuitionDue is the field that should be used for present_value, and of course there is type and future_value which I have both at 0).
YES, this is an assignment, but I so want to learn what I am doing here! I would appreciate any advice or insight!
The question is: Create another calculated field named TuitionPayments that uses the payment function and determines tuition paid in four installments. The student’s tuition payment and a 2.5% interest rate should be used in the function. Use 0 for the future_value and type arguments.
What I have inputted via the Expression Builder in the proper cell of the query is: TuitionPayments: «Expr» Pmt(.025, 4, [TuitionDue], 0, 0)
I am really wanting to learn! Am I way off base here? Should I have used brackets or parenthesis somewhere/somehow? Why is the error "The expression you entered contains invalid syntax" for what I inputted, when I followed the expression builder for both rate and num_periods (TuitionDue is the field that should be used for present_value, and of course there is type and future_value which I have both at 0).
YES, this is an assignment, but I so want to learn what I am doing here! I would appreciate any advice or insight!