Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2010
    Posts
    26

    Unanswered: substraction of two currency values results in parenthsis

    Hi all
    I have a query with two columns .
    column 1= Credit (Currency)
    Column 2= Orders (currency)
    When I try to subtract the credit from the orders in a third column the total is surrounded in parenthesis. I have Total:[Orders]-[Credit] $50-$5 the Total column would have the following ($45).
    I Even tried to convert the value to currency by using Total:CCUR([Orders]-[Credit]) and the result was the same.
    Can someone explain or direct me to some documents that would explain why this is happening.

    Thanks in advance.
    VIPER

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Check your data: this happens with currency format when the sum is negative.
    Have a nice day!

  3. #3
    Join Date
    Mar 2010
    Posts
    26
    Thanks Sinndho for your reply
    Yes it is a negative value.
    how can I change ($45) to -$45 if possible.
    Last edited by Viper5646; 02-23-14 at 11:51.
    VIPER

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You can always use a custom Format() function or (not recommended) change the settings in the Window control pannel.
    Have a nice day!

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    In the Format for the Control a simple 0 (zero) will do it.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    Join Date
    Mar 2010
    Posts
    26
    Thanks All for your replies.
    I have used Sinndho's suggestion and created a custom function.
    VIPER

  7. #7
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •