Number formats in Access 2000

  Mike D 11:53 21 Oct 2003
Locked

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.

Mike

  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

Epoc

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

Mike

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