×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Format negative numbers in report

Format negative numbers in report

Format negative numbers in report

(OP)
I have a report that has a calculation that is showing negative numbers as -98.  I would rather it use parentheses, (98), but can't figure out where to change how negatives display.

RE: Format negative numbers in report

Dear ,

Here is an example that formats a dollar field, has floating dollar sign, brackets negative number with ().
The first format is for positive, the second for negative and the third for zero values. It also change the negative value to red.

Place this value format field:
$#,##0.00[Black];(-$#,##0.00)[Red];$0.00[Black]

Hope This Helps,
Hap...

Access Developer  pc  http://www.fcs-software.com/fcsaccessdev.html
   Access based Accounting Solutions - with free source code
Access Consultants forum http://www.tek-tips.com/threadminder.cfm?pid=1121

RE: Format negative numbers in report

(OP)
That worked - except now it's giving me both (-98.0)

How do I get rid of the minus sign?

RE: Format negative numbers in report

Dear dhookom,

My thoughts exactly.

Sometimes I feel that those of us who offer the help are just doing the work for the others.

If someone can just give me a sample that comes close to solving my problem, I play with it until I get the result I want.

To bmoberly8888,

Just remove the '-' minus sign
ie...
#,##0.00;(#,##0.00);0.00

Hap...

Access Developer  pc  http://www.fcs-software.com/fcsaccessdev.html
   Access based Accounting Solutions - with free source code
Access Consultants forum http://www.tek-tips.com/threadminder.cfm?pid=1121

RE: Format negative numbers in report

(OP)
Thanks - that worked, and I'm sorry if it was a stupid question.  I would have played around with it and might have figured it out - I had never messed around with formats that weren't already listed.

What I don't understand is the attitude that you're doing other people's work for them - you don't have to answer the question.  I do appreciate your help and am sorry if you thought I should have figured it out myself.

RE: Format negative numbers in report

Dear bmoberly8888,

When someone helps another person, it is free advice.

If you had tried what I suggested and then attempted to revise it and that did not work, then I would have been more than happy to work you through the next problem.

But, if you plug in my suggestion and it does not do exactly what you want, and you ask me to fix it, well you do not learn anything, others reading this post will not benefit, bottom line, I will still know how to do it and no one else benefits.

Sometimes it just gets a little overwhelming. Not just me, but many other helpful people here making many suggestions/posts here all day long.

Also, the free advice does not cost anything, but when your problem is solved, in the Tek-Tips forum, you are suppose to award whomever helped by awarding them a star.

So, if someone helped you with this topic, where is the star for someone.

This is a technical forum, so I apolize for the rant, enough said.

Have a Great Day,
Hap...

Access Developer  pc  http://www.fcs-software.com/fcsaccessdev.html
   Access based Accounting Solutions - with free source code
Access Consultants forum http://www.tek-tips.com/threadminder.cfm?pid=1121

RE: Format negative numbers in report

(OP)
As soon as I hit "send" - I thought of that - but it was too late, the question had already been sent.  I have gotten help several times from Tek-Tips - and other times the answers maybe didn't work exactly - but put me on the right track to figure it out myself.  I don't expect other people to do my work for me, but I'm working on a very challenging (for me) project - and sometimes I just get stuck and need some help.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close