kariaheart
New member
- Joined
- Oct 22, 2011
- Messages
- 10
- Reaction score
- 0
- Points
- 0
Hi, have googled for a solution with no success so hoping to get help. Using Microsoft query through odbc connection have a table such as:
Item Type Qty
1 82 10
2 71 5
3 71 2
Qty values for Type 71 should be negative amounts. How can I amend the query to have the Type 71 display negative amounts while retaining the type 82's as positive amounts.
Thanks and kind regards
Item Type Qty
1 82 10
2 71 5
3 71 2
Qty values for Type 71 should be negative amounts. How can I amend the query to have the Type 71 display negative amounts while retaining the type 82's as positive amounts.
Thanks and kind regards