What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Please format my field...

Please format my field...
Author: Message:
lrac522
Full Member
***

Avatar

Posts: 317
Reputation: 9
– / Male / Flag
Joined: Jan 2006
O.P. Sad  Please format my field...
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!8o|8o|8o|8o|
[Image: signature3phpga4.png]
11-16-2006 07:53 AM
Profile E-Mail PM Find Quote Report
Eljay
Elite Member
*****

Avatar
:O

Posts: 2949
Reputation: 77
– / Male / –
Joined: May 2004
RE: Please format my field...
Change field type from Long Integer to Double.
11-16-2006 08:21 AM
Profile PM Find Quote Report
lrac522
Full Member
***

Avatar

Posts: 317
Reputation: 9
– / Male / Flag
Joined: Jan 2006
O.P. RE: RE: Please format my field...
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 !8o|8o|8o|8o|8o|8o|8o|
[Image: signature3phpga4.png]
11-16-2006 08:53 AM
Profile E-Mail PM Find Quote Report
lrac522
Full Member
***

Avatar

Posts: 317
Reputation: 9
– / Male / Flag
Joined: Jan 2006
O.P. RE: RE: RE: Please format my field...
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 !8o|8o|8o|8o|8o|8o|8o|

I FINAL GOT IT AFTER 24 HRS!! :banana:[Image: banana_flip.gif]:banana:[Image: banana_flip.gif] After using Eljay's method, all I had to do was to Compact and Repair. Thanks Eljay's
[Image: signature3phpga4.png]
11-17-2006 02:04 AM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On