Problem with rounding in MS-Access 2003

[Avery]

All my number data in Access 2003 automatically rounds to the nearest
interger, even when I request a 2 decimal place format. Is this a
known bug and is there a fix for it?

[Allen Browne]

Open the table in design view.
Select the problem field.
In the lower pane, change the Field Size propery from "Long Integer" to
"Double".

--
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.

"Avery" <av***@TodaysConstruction.com> wrote in message
news:94**************************@posting.google.c om...

All my number data in Access 2003 automatically rounds to the nearest
interger, even when I request a 2 decimal place format. Is this a
known bug and is there a fix for it?

[Pieter Linden]

av***@TodaysConstruction.com (Avery) wrote in message news:<94**************************@posting.google. com>...

All my number data in Access 2003 automatically rounds to the nearest
interger, even when I request a 2 decimal place format. Is this a
known bug and is there a fix for it?

Umm... show us the code! What kind of field are you storing it in?
Is it a Single or a Double or Currency? Otherwise, it'll get
truncated.

[MeadeR]

Make sure you're using the right numeric type when adding a field into
a table - the default is long - which is an integer

av***@TodaysConstruction.com (Avery) wrote in message news:<94**************************@posting.google. com>...

All my number data in Access 2003 automatically rounds to the nearest
interger, even when I request a 2 decimal place format. Is this a
known bug and is there a fix for it?