Shoutbox

I am having this severe problem with formatting my numeric field in Access 2007. I noticed when I entered a number eg. 7759.70 It would automatically round it off to 7760.00 while the decimal place value is set to 2, I tried everything possible, nothing seems to work which was so easy in 2003 version. Can you help please because I’m about to EXPLODE!

Change field type from Long Integer to Double.

quote:

---

Originally posted by Eljay
Change field type from Long Integer to Double.

---

Thank you so much but I can't believe this is happening, nothing seem to change. I spent nearly 4 hours unsuccessfully. I am so angry. AHHHHHHHHHHHHHHHHHHHHH !

quote:

---

Originally posted by lrac522

quote:

---

Originally posted by Eljay
Change field type from Long Integer to Double.

---

Thank you so much but I can't believe this is happening, nothing seem to change. I spent nearly 4 hours unsuccessfully. I am so angry. AHHHHHHHHHHHHHHHHHHHHH !

---

I FINAL GOT IT AFTER 24 HRS!! After using Eljay's method, all I had to do was to Compact and Repair. Thanks Eljay's