error in amortization query

[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!

 

[Matthias Klaey]

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

 

[shannonloveshealth]

"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

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

 

[shannonloveshealth]

Has ANYONE any info on Amortization Schedule using Access 2003 queries for 5 year loans??? ANYTHING IS HELPFUL!