More Scientific Function

  • Thread starter Thread starter Wayne
  • Start date Start date
W

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.
 
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
 
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.
Click to expand...

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

HTH
Matthias Kläy
 
Back
Top