Re: numeric fields
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 09/17/04
- Next message: anonymous: "Re: What database capacity does access have"
- Previous message: jenhj: "numeric fields"
- In reply to: jenhj: "numeric fields"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 17 Sep 2004 19:58:07 +0800
Open your table in design view.
Select the numeric field.
In the lower pane, change the Field Size from to Double.
The integer types can only store whole numbers.
The format and number of decimal places only affects how the number is
displayed, not how it is stored.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "jenhj" <jenhj@discussions.microsoft.com> wrote in message news:2839BC48-91DE-441F-8A09-579E54078BBE@microsoft.com... > Can anyone tell me why suddenly numeric fields in a very simple database > have > started rounding up & rounding down - ie I enter 4.25 and it displays > 4.00, > 1.75 displays as 2.00. I tried every combination of decimal places, > format > etc but nothing seems to stop it. I've never come across this prob before > and it's friving me nuts!!
- Next message: anonymous: "Re: What database capacity does access have"
- Previous message: jenhj: "numeric fields"
- In reply to: jenhj: "numeric fields"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
