I am wondering the following, per the manual:

quote:

Real/floating point math Floating point expressions are now supported, and various supporting functions have been added: Round, CInt, CDbl, CStr and FormatNumber

If we dig back into the MS-Access helpfile, we should also be seeing - CLNG..

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

I know this is not Access, but it would kinda neat to see some of these functions..

Another example, MID..

A cool function we can use from vb is Replace..

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's