Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing a debit to negative amount
Message
From
07/12/1999 11:48:04
Ed Rauh
Trumbull, Connecticut, United States
 
 
To
07/12/1999 10:56:07
Kevin Schmitt
Pengo Corporation
Laurens, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Changing a debit to negative amount
Miscellaneous
Thread ID:
00299782
Message ID:
00299806
Views:
23
>In Visual FoxPro 6, how in a query designer do you change all debit account to negative and keeping your credit positive and also keeping the same amount of records.
>
>
>for example
>
>trans_amt DBCR_IN
>64.76 D
>34.65 C
>
>the results would be
>
>trans_amt DBCR_IN
>-64.76 D
>34.65 C
>

Use an expression for trans_amt, such as:

IIF(DBCR_IN = 'D', 0 - trans_amt, trans_amt)
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform