converting single types to double types with an updateQuery

  • Thread starter Thread starter Jim Carlock
  • Start date Start date
J

Jim Carlock

Single: 89.658
Double: 89.6579971313477

I'm running an update query to convert Single elements to doubles. I know I
can limit the number of decimal places to display to make the number look
like the original number.

Is there another way around this or perhaps a suggestion? I think I'll just
leave them as Singlies... unless someone comes up with something relatively
easily.
 
You need to add a new field to the table of type Double, run an update query
to populate that new field (converting the existing Single fields to
Doubles), then get rid of the old Single field.
 
Douglas J. Steele said:
You need to add a new field to the table of type Double, run an update query
to populate that new field (converting the existing Single fields to
Doubles), then get rid of the old Single field.
Click to expand...

In the same table? I had created a new table, created a field of double. Then used an update query to update the field from the old table to the new table. I used an append query to create the same number of records and fill the initial field.

Strange thing happening:

I've forced it to 3 decimal places and the same results are happening. I opened up the single to display Auto decimal digits and they retained their 3 decimal digit max. When I forced the double to be 3 decimal digits as well, the double's ended up as I previously indicated:

tLnkMaterialOxide p2Materials p2OxideLabel Number Double
1 SiO2 89.658 89.6579971313477
1 Fe2O3 0.07 7.00000002980232E-02
1 Al2O3 0.09 9.00000035762787E-02


Don't know how that table is going to look when I post. Went into Rich Text Mode for the posting of this.
 
Douglas J. Steele said:
I don't understand what you think the problem is. 7.00000002980232E-02 is
.07. It's scientific notation: the E-02 means to multiply the value time 10
raised to the -2.
Click to expand...

Oof!

Just commenting. No problem. ;-)

7.00000002980232E-02 = .07
<!-- start of inclusion in small -->
+
..0000000002980232
<!-- end of inclusion in small -->

Microsoft indicates it being circumcised to three decimal positions is as
follows:

0.07 (3 decimal single) = 7.00000002980232E-02 (3 decimal double) = .07
<!-- start of inclusion in small -->
+
..0000000002980232
<!-- end of inclusion in small -->

For being such a small number, it sure does look awefully long!
 
Back
Top