April 21, 2008 at 3:51 pm
In MS Access, I have a table defined with some fields as numbers defined as type double. When I open up this table, I noticed the data is in a double format with a 2 decimal place.
I currently have a table defined in t-sql with the same data in it, but defined as floats. Some of the numbers that have decimal places run on to inifinite.
I want to mimic my definition in the MS Access table with a field that can take in a number with a double or floating format, but have a two decimal place.
Any suggestions are welcomed.
April 22, 2008 at 1:32 pm
Eric Weinstein (4/21/2008)
In MS Access, I have a table defined with some fields as numbers defined as type double. When I open up this table, I noticed the data is in a double format with a 2 decimal place.
I think that this may just be a formatting/display option in Access. A "Double" in MS-Access should be that same storage format as a "Float" in SQL server.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 22, 2008 at 2:26 pm
It's a display option. Access "double" = SQL "float". Same storage, same format.
If you're viewing the number on a form, set the display options for the field to determine how many decimal places. If it's when you open the table directly, set the options in the Access Tools, Options section.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply