How to change amount to negative

  • Thread starter Thread starter JIM
  • Start date Start date
J

JIM

Here's my query field BalDue which I'd like to show as a negative number.
What's wrong with it? It changes the first record fine and the second
remains unchanged.

BalDue:
Format((Nz([Invoices].[Labor])+Nz([Material])+Nz([BalanceDue])*-1),"00000000.00")

Output:
-0005000
0003500.50

TIA
 
Thanks MG, with an extra left paren and it works great! And it's all so
logical when I see it!


MGFoster said:
JIM said:
Here's my query field BalDue which I'd like to show as a negative number.
What's wrong with it? It changes the first record fine and the second
remains unchanged.

BalDue:
Format((Nz([Invoices].[Labor])+Nz([Material])+Nz([BalanceDue])*-1),"00000000.00")

Output:
-0005000
0003500.50
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It should be:

Format((Nz([Invoices].[Labor],0)+Nz([Material],0)+Nz([BalanceDue],0))
*-1,"00000000.00")

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **


-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSdT36YechKqOuFEgEQIjTwCgu55LipSm63KtweqZC0gBYx+s/NEAoO9J
as82udQ3m3DoDZLezE3ylVFo
=8buw
-----END PGP SIGNATURE-----
Click to expand...
 
Back
Top