More Scientific Function

[Wayne]

I can use these settings in a text box control, Format =
Scientific, Decimal Places = 4. The unformatted data is
556400000. I see this when I open the form: 5.5640E+08.

I want to replicate that result in a query.

I can use Format([Amounts], "Scientific") in the query and
I get 5.56E+08.

How can I get the query to produce 5.5640E+08?


Thanks to the replies to my previous question.

 

[Damon Heron]

Okay,
How about changing the field in the underlying table to scientific, 4
decimal places? The data could still be input as 556400000, but would be
converted in the table to scientific, and the results of any queries would
be expressed as scientific.

Damon

 

[Matthias Klaey]

I can use these settings in a text box control, Format =
Scientific, Decimal Places = 4. The unformatted data is
556400000. I see this when I open the form: 5.5640E+08.

I want to replicate that result in a query.

I can use Format([Amounts], "Scientific") in the query and
I get 5.56E+08.

How can I get the query to produce 5.5640E+08?


Thanks to the replies to my previous question.

Format$(556400000,"0.000E+00")

HTH
Matthias Kläy

 

[Wayne]

Thanks Matthias and Damon!

Both suggestions work well!

Thanks again.