converting single types to double types with an updateQuery

[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.

 

[Douglas J. Steele]

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.

 

[Jim Carlock]

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.

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!