Re: FLOAT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "David Gugick" <david.gugick-nospam@xxxxxxxxx>
Date: Thu, 3 Nov 2005 01:15:31 -0500

Rogers wrote:
> I only want to use float datatype because I have to frequenly convert
> the database into Access 97 and Access doesn't support decimal and
> numeric datatype.
>

Access 2003 ( I realize this is not Access 97 - but that version is almost 9
years old) has a Number Data Type, which can then be qualified with the
"Number" type. Choice abound:
- Byte
- Integer
- Long Integer
- Single
- Double
- Replication ID
- Decimal - which has precision and scale to match that used by SQL Server

--
David Gugick
Quest Software

.

References:
- FLOAT
  - From: Rogers
- Re: FLOAT
  - From: Hugo Kornelis
- Re: FLOAT
  - From: Rogers

Prev by Date: Re: Version of MDAC for SQL 2005?
Next by Date: Perfact matching query?
Previous by thread: Re: FLOAT
Next by thread: Re: FLOAT
Index(es):
- Date
- Thread

Relevant Pages

Re: FLOAT
... >I only want to use float datatype because I have to frequenly convert the ... >database into Access 97 and Access doesn't support decimal and numeric ... I could enter and retrieve data without any problems ... Prev by Date: ...
(microsoft.public.sqlserver.clients)
Issue in using round in Vbscript
... I am using a Round to get the Value of a Float datatype column from a database ... It do returns a value as 0 but it stores it into a table it's -1 my column for Temp is of Float datatype ...
(microsoft.public.sqlserver.server)
RE: Issue in using Round
... I am using a Round to get the Value of a Float datatype column from a database ... It do returns a value as 0 but it stores it into a table it's -1 my column for Temp is of Float datatype ...
(microsoft.public.sqlserver.server)