Problem with rounding in MS-Access 2003

#1

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?

#2

Integers are whole numbers (no decimals). If your data requires decimal support, change the column
datatype to single or double (consult the help file to determine which is adequate for your needs).

"Avery" <avery (AT) TodaysConstruction (DOT) com> wrote

Quote:

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Problem with rounding in MS-Access 2003

comp.database.ms-access comp.database.ms-access

Problem with rounding in MS-Access 2003 - 10-22-2003 , 09:56 AM

Re: Problem with rounding in MS-Access 2003 - 10-22-2003 , 04:03 PM