Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Present negative numbers as positive (Access2000)

    Hi guys,
    Is there anyway I could present all numbers inc. negative as positive in a query?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    Hi Princess,

    I don't understand the question very well.
    If you want all numbers, don't put a condition in your query.
    If you want all numbers, but not 0, then use <>0
    Francois

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Present negative numbers as positive (Access2000)

    Hi,
    Use the Abs() function to convert all numbers to positive values.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    Yes, I definitely have to learn to read all the words of a question <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Francois

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    Thanx guys!
    Another favour?
    I wanna have a criteria in the query so that the query wont pick up foreign exchange trades. the only way to finda out whether the trade is foreign exchange is by looking at the data in the ID feild. The data would be currency (GBP/EUR/CHF, etc) its always 3 letters eg GBP, EUR, etc.
    Is there anyway I could do this without listing all the currencies??

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    If I well understand the question this time, you can use the column to filter the data but make it invisible by uncheck the Show checkbox in the design view.
    Francois

  7. #7
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    Thanx Francois but you have to tell me how I could do this coz I really don't know how.

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Present negative numbers as positive (Access2000)

    What do you classify as being a foreign exchange trade? Any non-sterling trade, any non-sterling or non-euro trade, any non-EC trade or what?
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    See Attachment
    Attached Images Attached Images
    Francois

  10. #10
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    What I meant by foreign exchange: e.g. I buy US dollars for GB pounds etc.
    dealing with the money rather than buying stocks.
    Francois, I didn't wanna do it like that coz I will have to list alot of currencies if i did.

  11. #11
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    Can you explain more in detail what you want?
    Francois

  12. #12
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    I don't know how I could do it but if the data length is 3 then it shouldn't pick it up (this is not a good way of doing it coz there might be other Id's which r not foregn exchanges) but i don't know any other ways.

    Any other suggestions??

  13. #13
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    I'm not sure I understand what you mean, but if you want all the id that have not 3 characters you can use the filter :
    len([idField])<>3
    Francois

  14. #14
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Present negative numbers as positive (Access2000)

    Hi,
    I would have said that your best bet was a separate table with all the currency codes in it (useful to have this anyway so you can have a description of the currency rather than just something like 'NLG') which you can then link to your query with an outer join. You can then include the ID from this new table and specify Is Null in the criteria to return anything that doesn't match one of these currency codes.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  15. #15
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Present negative numbers as positive (Access2000)

    What is in the ID field when it is NOT a foreign exchange trade?
    Legare Coleman

Page 1 of 2 12 LastLast

Posting Permissions

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