data format

[AccessWater]

hello, Not sure if this is right placeto post.

In the subreport, I calculated a difference between budget and actual. I want to present this difference in a way that if it is positive, then just show it the way it is, but if it is a negative number, I want to show it in a (). FOr example, if it is -123, I want to show it as (123).

Can anybody help me with it?

Thank you.

 

[SamDeMan]

you need to format the textbox that holds the "difference between budget and actual" with custom formating. try this: #,###.00;(#,###.00)

if you open excel and go to help type in something like "custom format" you will see a better explanation and description of this.

sam

 

[AccessWater]

Thank you very much, Sam. It works. I will go to get more info. about this.