Tuesday, June 08, 2004

 

Functions With Names Beginning With O

First, my apologies for the long, unannounced hiatus in posting – I had a one week holiday, and then it took me another week to get caught up on all the things that piled up during the holiday, you know how that goes!:-)

Continuing our alphabetical investigation of VBA functions that can be used in Jet queries, there are just two functions (or two variations of one function) with names beginning with the letter ‘O’, the Oct() and Oct$() functions. Both of these functions work as documented in queries both within Access and when executed via our C# ‘JetTest’ utility (see previous posts). Here’s the SQL statement for a query that uses these two functions:

SELECT 
    Oct([TestInteger]) AS TestOctVar, 
    Oct$([TestInteger]) AS TestOctString 
FROM tblTest;

So we can add these two functions to our list of VBA functions that can be used in Jet queries when executed outside the Microsoft Access environment:

The Oct() and Oct$() functions.


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:
I used to be suggested this website by way of my cousin.
I'm no longer positive whether this submit is written by means of him as no one else realize such specified approximately my problem. You're wonderful!
Thank you!

My web page - Pba root canal
 
Post a Comment

<< Home

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