Scientific Function

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

Wayne

In this query:

SELECT CCur(tblABC.Amounts)
FROM tblABC

The values in the Amounts field are formatted as Currency.

I want the field Amounts to be formatted as Scientific.

Is there a function for this?

Thanks!
 
In this query:

SELECT CCur(tblABC.Amounts)
FROM tblABC

The values in the Amounts field are formatted as Currency.

I want the field Amounts to be formatted as Scientific.

Is there a function for this?

Thanks!
Click to expand...

Format([Amounts],"Scientific")
 
Thanks Fred - that works.


Now they want the scientific format to 3 decimal places...

CDec(Format([Amounts],"Scientific"), 3) or something like
that? Actually that one does not work.

Thanks!
 
Scientific shows it with the Exponent - why not just go directly to 3
decimals with: format([Amounts],"######.###")

Damon
 
The users want to see it this way.

I'll repost this question now that I do know how to at
least get it in Scientific notation.

Thanks Damon,
Wayne



-----Original Message-----
Scientific shows it with the Exponent - why not just go directly to 3
decimals with: format([Amounts],"######.###")

Damon

Thanks Fred - that works.


Now they want the scientific format to 3 decimal places...

CDec(Format([Amounts],"Scientific"), 3) or something like
that? Actually that one does not work.

Thanks!
Click to expand...


.
Click to expand...
 
Back
Top