error in amortization query

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

Guest

I am trying to build an amortization query in Access 2003 using the PMT
function and I keep getting the following error;

Compile error. In query expression 'PI Amort Check: Pmt([200 Note
Information]![Original Note Rate]/1200,[200 Note Information]![Amortized
Term],-[200 Note Information]![Original Note Balance])'.

I followed this function perfectly according to the help documentation. Is
there something i am over looking??

Thanks for your help!
 
Antoni Ross said:
I am trying to build an amortization query in Access 2003 using the PMT
function and I keep getting the following error;

Compile error. In query expression 'PI Amort Check: Pmt([200 Note
Information]![Original Note Rate]/1200,[200 Note Information]![Amortized
Term],-[200 Note Information]![Original Note Balance])'.

I followed this function perfectly according to the help documentation. Is
there something i am over looking??

Thanks for your help!
Click to expand...

Most probably you need to use the semi-colon ";" to separate the
parameters of the function, not the comma ","

PI Amort Check: Pmt([200 Note
Information]![Original Note Rate]/1200;
[200 Note Information]![Amortized Term];
-[200 Note Information]![Original Note Balance])

In a query you use the "List Separator" as defined in the
"International Settings" or "Regional Settings" of your computer to
separate parameters in a function call, as opposed to VBA, where you
always use the comma.

HTH
Matthias Kläy
 
Matthias Klaey said:
"Antoni Ross" <[email protected]> wrote:

>I am trying to build an amortization query in Access 2003 using the PMT
>function and I keep getting the following error;
>
>Compile error. In query expression 'PI Amort Check: Pmt([200 Note
>Information]![Original Note Rate]/1200,[200 Note Information]![Amortized
>Term],-[200 Note Information]![Original Note Balance])'.
>
>I followed this function perfectly according to the help documentation. Is
>there something i am over looking??
>
>Thanks for your help!

Most probably you need to use the semi-colon ";" to separate the
parameters of the function, not the comma ","

PI Amort Check: Pmt([200 Note
Information]![Original Note Rate]/1200;
[200 Note Information]![Amortized Term];
-[200 Note Information]![Original Note Balance])

In a query you use the "List Separator" as defined in the
"International Settings" or "Regional Settings" of your computer to
separate parameters in a function call, as opposed to VBA, where you
always use the comma.

HTH
Matthias Kläy
--
www.kcc.ch


http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
Click to expand...


Have you managed to create a PMT Formula driven query in MS Access 2003?
 
Back
Top