format a query with a -(negatve) or +(positive) in the result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a query that subtracts [purchaseprice]-[value] to give cardworth. The result is being displayed as ($5.00) for positive worth and $5.00 for negative value, or loss. How can I display -$5.00 and +$5.00 for result?
 
Hi,

You wrote:
"I've created a query that subtracts [purchaseprice]-[value] to give
cardworth. The result is being displayed as ($5.00) for positive worth and
$5.00 for negative value, or loss. How can I display -$5.00 and +$5.00 for
result?"


I maybe miss understanding your question but have you tried just
multiplying the result by -1?

Example: ([purchaseprice]-[value])*-1


Thank you for using the Microsoft Access Newsgroups.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
 
I've created a query that subtracts [purchaseprice]-[value] to give cardworth.
The result is being displayed as ($5.00) for positive worth and $5.00 for
negative value, or loss. How can I display -$5.00 and +$5.00 for result?

Try setting the "Format" property for the relevant field (column) in the query
to "$#,###.00".
 
Back
Top