Gustav Brock
gustav at cactus.dk
Tue Oct 14 13:07:20 CDT 2003
Hi Robert Just a note. >>The exceptions are only those where the numbers exceed the capacity of >>your database engine, normally at least 14 digits (Jet: Currency) and >>a Long Integer is always available which holds 9 digits. > RLS: By using scientific notation, you can go past this also. > Decimal = 10 ^28 -1 That's right but the Decimal datatype was not used by the Jet engine before version 4 (Access 2000). For A97 and earlier that means you would have to store it in some fancy way using compound fields or, say, like a string! /gustav