NPV Calcuation From same column using same rate in sql

[borntorun]

Hi Guys,

I would like to calculate the NPV in a sql query but use the vba function.

Does anyone hvae some pointers about how i can do this?

I will always use the same column. I want to hard code the base rate to begin with and then put it from a column later.

I think i hvae to create a module that takes the column turns it to a double?

Never used a vba function in a query.

THanks.

 

[borntorun]

Guys,

I am gonna try from the following article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;268159

HOpe this helps someone as well.

Thanks