Numeric field problem

[OracleScorpion]

In my database, I've got a numeric field which has to store up to 7 numbers of which 2 are decimals. Now I tried everything in the notation and number of decimals etc but whatever I do, it keeps going wrong. If I fill in 59,31 (the 31 is the decimals) I get as a result either 5931 of 59.

Can someone give me what I need to fill in as field details for this to work?

Thanks in advance!

 

[RoyVidar]

You will need to use single or double as field size, or perhaps currency datatype. I suspect you are using integer or long integer.

Roy-Vidar

 

[OracleScorpion]

Ack... now you say so. Normally at work I use the english version. But here at home I have the dutch version and I am not used to the names in it. Thanks a bunch!

Just one more question. I need to get a comma as limiter for decimals, any idea how to?

 

[RoyVidar]

Regional Settings in Control Panel?

Roy-Vidar

 

[OracleScorpion]

*sighs* thank you once more!

It's a saturday evening and I'm working on a project for work, my apologies that my brain is slightly in weekend-mode *blushes*

Thank you ^-^