Tuesday, May 18, 2004


Functions With Names Beginning With N

There are just three VBA functions with names beginning with N, the Now, NPer, and NPV functions. The NPV function takes an array as its second argument, and like all of the functions involving arrays that we have tested so far, it proved unusable in a query executed within the Microsoft Access environment. The following SQL statement includes the remaining two functions, Now and NPer:

    Now() AS TestNow, 
    NPer(1.2,2.3,3.4) AS TestNPER 
FROM tblTest;

This query executed without error both within the Microsoft Access environment and via the JetTest utility, so we can add these two functions to our list of functions that can be used in Jet queries executed outside of the Microsoft Access environment:

Now and NPer.

Send feedback on this post to (change the obvious):

Brendan Reynolds
bwnnfb at hotmail dot com

(For the insatiably curious, "bwnnfb" is an acronym for "Blog With No Name Feed-Back")

Copyright © 2004 Brendan Reynolds. All rights reserved.

Comments: Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?