sparks wrote:
After changing all the variables in a table from long to double.
you get 9.1====becomes= === 9.1999998092651 4
ok I checked microsoft and they had a workaround.
export the values to excel...then import them back into the new table.
well I tried that and get the same thing.
is there a work around for the work around LOL
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
9.1 would not "fit" in a Long column. Longs are large Integers (no
decimals). So my guess is that you originally had a TEXT column w/
decimal numbers as the values.
One tedious way to change the text values to Double values would be to
create a new table that has the same columns as the original table,
except change the numbers Text column to a Double data type. Then
import all the rows from the original table into the new table using an
Append query - like this (say colC is the converting column):
INSERT INTO <new table name(colA, colB, colC)
SELECT colA, colB, Val(colC)
FROM <old table name>
Then delete the old table (or rename it for safety's sake) and name the
new table w/ the old table's name.
--
MGFoster:::mgf0 0 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBR1XXnoechKq OuFEgEQL/XwCdE8LrW3ykVnb BMaYa8KigAmU4Me IAn1Q+
5lTUXLNy7Jerrki ISfMXeAHS
=qGRG
-----END PGP SIGNATURE-----