Displaying negative values in a report with parentheses around them

[billelev]

This is probably very easy, but I can't see how you would do this...

I have a table that is used as a source table for a report. The table contains percentage values. In the report, I would like to display percentage values less than zero with parentheses around them. I can change the color, format etc. but I'm not sure how you would enclose a particular field in this way.

e.g. -5.6% becomes (5.6%)

[Jim Doherty]

This is probably very easy, but I can't see how you would do this...

I have a table that is used as a source table for a report. The table contains percentage values. In the report, I would like to display percentage values less than zero with parentheses around them. I can change the color, format etc. but I'm not sure how you would enclose a particular field in this way.

e.g. -5.6% becomes (5.6%)

Create a query and place the numeric field in the query grid now in the column to the right of that type this (where 'pcent' represents your field name). You could then base your report on the query (obviously you would add other fields from your table to do that.

The calculated column strPercent then becomes available in your report as a string value in addition to your numeric value so you have the best of both worlds

strPercent: "(" & CStr([pcent]) & "%)"

Regards

Jim :)

[billelev]

Thanks, Jim. So I guess it is not possible to do it directly in the report itself, then?

[Jim Doherty]

Thanks, Jim. So I guess it is not possible to do it directly in the report itself, then?

I personally always make reports based on queries, the queries of which I make give me the data to provide for the report.

You can do this in the report only if you wish, but it would be a calculated control like a textbox that would take the value of whatever is in the percent textbox and format it in much the same way ie in an unbound textbox enter into its controlsource

 ="(" & CStr([pcent]) & "%)"

Jim :)

[missinglinq]

Actually, you can do this in a report, a form or a table (anywhere where the Format property is available) for currency/number datatype fields by placing

0;(0)

in the Format property!

Linq ;0)>

[billelev]

Actually, you can do this in a report, a form or a table (anywhere where the Format property is available) for currency/number datatype fields by placing

0;(0)

in the Format property!

Linq ;0)>

Perfect! That is exactly what I was looking for. Thanks.

[missinglinq]

Glad we could help!

Linq ;0)>