Hi ,

I thought I new this but im am stummped, I have a Domain that we have defined as Decimal(6,2) We have launched our project and started importing data into the fields...all goes well until we find that our imported figure of 30,000,000.00 is converted into -12,949,672.96

So I thought id change the Domain to say DECIMAL 18,2 ...Wey Hey it now lets me store 30,000,000.00 correctly.

In Helens Book/Bible on Page 134 DECIMAL data type, it says that DECIMAL(4,1) WILL STORE +/-214,748,364.7 , AS I WAS USING 6,2 WHERE DID I GO WRONG..

I KNOW ITS AN EMBARRASING QUESTION TO ASK.... please dont rub it in..

Thanks
Colin