Need to show minus value in brackets ()

P

Prince

Hi,
I am making a report with different text fields one text fields is
calculating variance which I need to print in brackets instead of "-" sign.

Any suggestions please ???
 
K

KARL DEWEY

Calculating Variance: IIF([YourField] <0, "("& Abs([YourField]) & ")",
[YourField])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Printing Outline view - formatting lost 0
Descenders clipped 0
Word OLE to check spelling in text box 1
OLE Word spelling 0
Page numbering with Merged Document and IF statements 1
Minus equal null 4
Calculate the median value before a specified list 0

Top