When i input a decimal value in a table it turns to zero?

[aledlfc]

Hi

I have created a booking and i want to have a field which has a discount of 20% (0.2). So i created my new field and then new form and entered 0.20 soon as i move to next booking it automaticaly changes back to zero. I thought i got round this problem but making the number a single this allowed me to input the 0.2. But when i created the query to caluclate the discount to be taken away from gross cost i get the answer #######. The caluclation i used was [Gross Cost]*[Discount].
Could you please tell me where i have gone wrong and methods i can overcome this problem?

Thanks

Aled

 

[Rabbie]

We are not telepathic so it would be helpfl if you can tell us what type the relevant fields are declared as or even better if you could post your DB

 

[statsman]

This sounds exactly like what happens when you do division and there art too many decimal places to be displayed.

Try changing the format of the field to standard and limit it to 2 decimal places.

 

[PaulO]

1. Make the field's Data Type = Number
2. Then in its properties
   • make the Field Size = Double
   • make the Format = Percent
   • make the Decimal Places = 0
3. The result will be a value entered as .2 but displayed as 20%

 

[gemma-the-husky]

it sounds like the field is defined as an integer. it needs to be a single or double to include decimal points, as paulo says.