UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> formatting negative numbers    
 
   
michaela4
post Aug 24 2007, 10:30 PM
Post #1

UtterAccess Ruler
Posts: 1,395
From: Tulsa, Oklahoma
How can I format a field on my table to show a negative number with the minus sign instead of parenthesies?

-366 instead of (366)

Thanks

Michael
Go to the top of the page
 
+
Rainlover
post Aug 24 2007, 10:40 PM
Post #2

Utterly Banned
Posts: 6,006
From: Brisbane Qld Australia
Formating with

Data Type as Number
Field size as Double
Decimal Place as Auto

Should do the trick.

If not what have you got?
Go to the top of the page
 
+
HiTechCoach
post Aug 24 2007, 10:49 PM
Post #3

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
? Format(-366,"#")
-366

? Format(-366,"#;(#)")
(366)
Go to the top of the page
 
+
michaela4
post Aug 27 2007, 12:52 PM
Post #4

UtterAccess Ruler
Posts: 1,395
From: Tulsa, Oklahoma
I forgot to mention it has to be a currency data type.

thanks
Michael
Go to the top of the page
 
+
balaji
post Aug 27 2007, 12:54 PM
Post #5

UtterAccess VIP
Posts: 5,635
From: Chicagoland, USA
Will the below work for you?
QUOTE
?format(-366,"$#.00")
-$366.00
Go to the top of the page
 
+
« Next Oldest · Access Tables + Relationships · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 03:11 PM