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

Galaxy Note 8 vs iPhone X

The secrets of creating gory VFX

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache