Number formats in Access 2000

  Mike D 11:53 21 Oct 2003

I am sure that the answer to this is so simple, but for the life of me I can't figure it out.

When entering numbers into a table in a database that i have created i cannot get decimal places to show, even though I have tried to force this by using "2 decimal places " and fixed decimal places. Not only does the decimal place not show, but the entry is rounded to the nearest whole number.

Please help before I lose what little hair I have left.


  Epoc 12:02 21 Oct 2003

You need to set the Field Size to Double rather than decimal.

  Mike D 12:10 21 Oct 2003


I knew you wouldn't let me down - and in record time.
Thanks muchly, I've tried it and it works1


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires