Table Setting

[Meehphill]

I've been trying this for a few hours, What do i need to do, or set, when I have currency value greater then 2.5 Trillion....seems like I can paste any other vaule into the table except value greater then 2.5 trillion.

can anyone help me, thanks

Phill

 

[SOS]

Use the NUMBER datatype and use DECIMAL as the specific type. If you don't need decimal points just leave the Precision property's default to 18 and leave SCALE at 0. If you need 2 decimals then change the Precision default to 16 and SCALE at 2.

 

[rzw0wr]

Be aware that Decimal has some problems.

Google Access decimal type to get an idea.

Dale

 

[SOS]

Be aware that Decimal has some problems.

Google Access decimal type to get an idea.

Dale

According to the MS KB article - http://support.microsoft.com/kb/837148, it only applies to MDB files. And it does have a workaround if used in an MDB file. Create an INDEX (YES/ALLOW DUPLICATES) before any sorting is done.

 

[Meehphill]

Thank YOu everyone !