Number formats in Access 2000

  Mike D 11:53 21 Oct 03

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 03

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

  Mike D 12:10 21 Oct 03


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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…