Setting Significan Figures in a SQL Statement

[SDIG]

I want to make this line say $99.99 per SF...Here is my SQL statement.

="$" & Str([SubtotalLF]) & " per SF (gray colored block) Note: Additional $.xx/sq.ft. for colored units."

I am attempting to set the significant figures to 2 . I have tried setting the Format Property to Currency and to fixed with a decimal value of 2 and both have no effect and were unsucessful. I have determined that I have to set the value in my SQL statement. How would I make this work?

KB

 

[tlbroadbent]

You can use format in an Access query. I assume you are using Jet SQL in Access.

Format([SubtotalLF], "0.00&quot Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[BoxHead]

SDIG,

I'm wondering if you could set the field's format property to currency, eliminate the dollar sign and NOT convert it to a string with the Str function you're now using. That 'Str' is probably what is keeping the formats from having an affect.

=

"$" & Str

([SubtotalLF]) & " per SF (gray colored block) Note:  Additional $.xx/sq.ft. for colored units."

HTH John

Use what you have,
Learn what you can,
Create what you need.