Posts: 278 Joined: 12/6/2002 From: Out in the sticks, UK Status: offline
Access db not showing numbers to 2 decimal places - 11/17/2004 19:26:58
Help!
I've got a table in an Access db but it will not let me include any numbers after the decimal place. so 7.30 becomes 7.00
What/how should this column/field be formatted?
thanks
_____________________________
The more I ask, the more I learn, the more I' m confused, therefore the more I ask ...
BeTheBall
Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline
RE: Access db not showing numbers to 2 decimal places - 11/17/2004 21:43:37
Make sure it is not set as integer or long integer, which I believe is the default setting. I would go with double.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.