How do I show a negative control as a positive number

  • Thread starter TonyWilliams via AccessMonster.com
  • Start date
T

TonyWilliams via AccessMonster.com

I have a calculated control on a report where the value is shown as -45. How
can I format this number to show it as 45?
Thanks
Tony
 
T

Tom Lake

TonyWilliams via AccessMonster.com said:
I have a calculated control on a report where the value is shown as -45. How
can I format this number to show it as 45?
Thanks
Tony
Click to expand...

=Abs([FieldName])

where FieldName is the name of the field calculated.

Tom Lake
 
T

TonyWilliams via AccessMonster.com

Thanks Tom worked just fine!
Tony
Tom said:
I have a calculated control on a report where the value is shown as -45. How
can I format this number to show it as 45?
Thanks
Tony
Click to expand...

=Abs([FieldName])

where FieldName is the name of the field calculated.

Tom Lake
Click to expand...
 

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

Defining variables as row numbers 1
checking for positive or negative numbers 1
Negative number alignment 1
Another Time Related Question 7
Paragraph numbering in Word 1
Mail Merge - displaying a conditional number of decimals 5
How can the font and size of (all) citation numbers be altered? 1
Scroll does not show preview 0

Top