Concise list of Jet functions

[Brian]

Can someone please direct me to a listing of Jet functions & data types?
While I have a fair amount of Access programming under my belt, a current
project has me providing data via queries called by an ADO.NET interface
developed by another developer. Of course, I cannot use any of my custom
functions, only the native Jet functions (IIf, Date(), etc.). To save some
trial-and-error, I would like to obtain some Jet reference material that
lists the functions available natively so that I know what I can safely embed
in my queries.

I found out the hard way that NZ() does not work, and had to replace it with
IIf (IsNull...). While I do not have any problem doing that, it would help
immensely to know the limitations by refeence rather than doing everything by
trial-and-error.

 

[Douglas J. Steele]

I'm not sure there is a comprehensive list anywhere, although former MVP
Brendan Reynolds has most of it documented at http://brenreyn.blogspot.com/
(he got as far as functions starting with S)

Coinicidentally, I was in correspondence with Brendan just the other week
about this very topic, asking him whether he was going to continue it (and
check for Access 2007 and 2010), or whether he wanted someone else to take
over the task. He said he would try to find his original samples to see
whether it was easy to continue or not, but he hasn't got back to me yet.

 

[Brian]

Thanks, Douglas. It looks like Brendan was doing it all by trial and error. I
am a little surprise that MS does not provide a reference list of all
functions on TechNet or somewhere.

 

[David W. Fenton]

I
am a little surprise that MS does not provide a reference list of
all functions on TechNet or somewhere.

This is a consequence of Microsoft failing to distinguish Jet from
Access. It's just getting worse with A2007 and the so-called "Access
Database Engine," as they are styling it now (and they are
purposefully using that term to encompass both Jet and the ACE
*sigh*).