Financial Functions

[Rats]

I am doing some work on a loan calculator which I have done successfully in Excel. I now wish to do this with an Access form (A2K). Can anyone please confirm that the Financial Functions (ie CUMPRINC etc) that are available in Excel can be used in Access. The Access help menu calls them Worksheet Functions and I can't see any reference to the above function in this forum. I have entered it in a control and get a #name? error. I dont know if I have made a syntax error or that Access doesn't recognise it.The following is the formula I have used =CUMPrinc([rate]/[freq],[nper],[amount],1,[nper],0).

I have not had the same problems with the following formula =PPmt([rate]/[freq],1,[nper],[amount],0)

Cheers

 

[KenHigg]

You should be able to use Excel functions if you set them up in Tools->References. I think it is listed 'Microsoft Excel 11.0 Object Library'.

Hope this helps...

 

[Rats]

I have found and set up Microsoft Excel 9.0 Object Library (can't find 11.0, assume it is a version later that A2K). I have made sure that msowcf.dll is installed but still no joy. I have tried to create a Principal calculation formula of my own but need the Power Function, this doesn't work as well.
Any suggestions please?