Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Musgrove42

    How to calculate NPV ( Net present value ) in a query

    I have a query that has 5 calculated payments - the interest rate is stored in a form. I need to work out how to calculate NPV. The problem is that the 5 calculated payments need to go into an array and be specified as double. I cant work out how to do this. Can anyone help me please? Thanks
  2. Musgrove42

    Roundup Function in Excel - Access Equivalent?

    Thanks - got it sorted! My values can be negative as well - so it complicates things. Thanks for your help
  3. Musgrove42

    Roundup Function in Excel - Access Equivalent?

    Does anyone know how to replicate the roundup function of Excel in Access? Im new at using Access and was wondering if anyone knows how to do it without using VBA. ALl I want to have is a function that makes any number with a decimal round up to the nearerst integer. Thanks!!!
  4. Musgrove42

    Roundup function in Access 2003

    Does anyone know how to replicate the roundup function of Excel in Access? Im new at using Access and was wondering if anyone knows how to do it without using VBA. ALl I want to have is a function that makes any number with a decimal round up to the nearerst integer. Thanks!!!

Part and Inventory Search

Back
Top