Data type problem

[Pyscho]

I have a field called 'Discount' in my table called 'Bill'. I set the data type of the Discount field to 'Number' along with..

Field size: Long integer
Format: currency

But my problem is, when i type in, for e.g, £4.50 it changes it to £5.00. It keeps rounding it up to the nearest pound. How can i stop this happening?

 

[KenHigg]

Change from integer to double and read up on the definition of an integer

kh

 

[The_Doc_Man]

Or change the field type to Currency to match the format. Read up on the Currency data type, which is a scaled, double-long integer.