I'm not sure how much clearer I can make it than is already explained in Access or Excel Help. There are examples as well in both programs' Help.
If you want to find the monthly payment for a 30 year loan at 6.5% APR for $50,000, then you enter PMT(.065/12, 360, -50000) If you want to find the principal payment for the 18th month of the same loan, you would enter PPMT(.065/12, 18, 360, -50000) HTH, Toby ----- Original Message ----- From: "rajeev vasu" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, September 22, 2005 10:49 AM Subject: Re: [AccessDevelopers] PMT and PPMT > Dear Johnson, > > I was also searching for the same. It is explained in > Access help. But I don't know how to use it. Will you > please elaborate ? > > - Rajeev > > > > --- Lonnie Johnson <[EMAIL PROTECTED]> wrote: > > > Sorry. I didn't know that these were Access > > functions as well. Problem solved. > > > > Lonnie Johnson <[EMAIL PROTECTED]> wrote:Does > > anyone know how to convert or duplicate Excel's PMT > > and PPMT loan functions in MS Access? > > > > > > > > May God bless you beyond your imagination! > > Lonnie Johnson > > ProDev, Professional Development of MS Access > > Databases > > Visit me at ==> http://www.prodev.us > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------- > > Yahoo! for Good > > Click here to donate to the Hurricane Katrina relief > > effort. > > > > > > Please zip all files prior to uploading to Files > > section. > > > > > > > > SPONSORED LINKS > > Microsoft access developer Microsoft access help > > Microsoft access database Microsoft access training > > Microsoft access training course Microsoft access > > programming > > > > --------------------------------- > > YAHOO! GROUPS LINKS > > > > > > Visit your group "AccessDevelopers" on the web. > > > > To unsubscribe from this group, send an email > > to: > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the > > Yahoo! Terms of Service. > > > > > > --------------------------------- > > > > > > > > > > > > > > May God bless you beyond your imagination! > > Lonnie Johnson > > ProDev, Professional Development of MS Access > > Databases > > Visit me at ==> http://www.prodev.us > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------- > > Yahoo! for Good > > Click here to donate to the Hurricane Katrina > > relief effort. > > > > > __________________________________________________________ > Yahoo! India Matrimony: Find your partner now. Go to http://yahoo.shaadi.com > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
