sub form problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=Pmt(InterestRate/12,term*12,-Amount,0,0)is the formula I am using to compute
the Payment Due in a loan subform but whenI view the form the form has
#name? where the payment is supposed to be. What am I doing wrong???
 
usually, the #Name? display signifies that Access cannot identify one or
more of the fields referenced in the expression. double check each field
name that you're using in the Pmt() function, make sure that each field is
included in the form or report RecordSource, and make sure that the control
in which you placed the function does not have the same name as any of the
referenced fields.

hth
 

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

Similar Threads

Payment Due in subform 1
CUMIPMT 0
Have #Error ignore blank entries 4
numerical summation to passed from sub to main form 2
Creating auto loan database 15
Reducing Balance on Invoice 9
PMT function question 2
Running Sum In A Form 6

Back
Top