# Thread: Present negative numbers as positive (Access2000)

1. ## Present negative numbers as positive (Access2000)

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

2. ## 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

3. ## Re: Present negative numbers as positive (Access2000)

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

4. ## 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>

5. ## 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. ## 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.

7. ## 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. ## 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?

9. ## Re: Present negative numbers as positive (Access2000)

See Attachment

10. ## 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. ## Re: Present negative numbers as positive (Access2000)

Can you explain more in detail what you want?

12. ## 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. ## 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

14. ## 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.

15. ## Re: Present negative numbers as positive (Access2000)

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

Page 1 of 2 12 Last

#### Posting Permissions

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