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

Samsung Galaxy S9 review

Explore Milton Glaser's iconic poster designs from the 1960s to present, including Bob Dylan, I…

What to expect at Apple's 27 March education event

Idées cadeaux pour geeks et tech addicts