If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I show a negative control as a positive number
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 -- Why don't my grey cells communicate with each as fast as they used to? I hate getting old! Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
How do I show a negative control as a positive number
"TonyWilliams via AccessMonster.com" u56994@uwe wrote in message news:a219779e31378@uwe... 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 =Abs([FieldName]) where FieldName is the name of the field calculated. Tom Lake -- "I'll sue them again," Tom retorted. |
#3
|
|||
|
|||
How do I show a negative control as a positive number
Thanks Tom worked just fine!
Tony Tom Lake wrote: 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 =Abs([FieldName]) where FieldName is the name of the field calculated. Tom Lake -- "I'll sue them again," Tom retorted. -- Why don't my grey cells communicate with each as fast as they used to? I hate getting old! Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
Thread Tools | |
Display Modes | |
|
|