Currency rounding up to nearest whole number

[Ian-W-]

Hi,

I'm creating a stock tracking database. I need to enter weekly rental charges such as £1.35.

When i enter £1.35 it is rounding it to £1.00

If i enter anything over £1.50 then it rounds to £2.00

I need it to show the exact amount, how do I do this.

Thanks
Ian

 

[Mile-O]

Give info on your table: format, decimal places, etc.

 

[Ian-W-]

Sorted now boss.

I had the field set as a number and then the format as currency.

I just set the filed to currency and it works.

Thanks

Ian

 

[Mile-O]

As an extra, if you want to put decimal values into a normal numeric field then you need to set the format to Single.