Convert Number To Negative Based on Another Field's Value? 1

[Hakala]

Hi, Tek-Tippers!

I have a subform which I want to show me a running sum (great FAQ on that!), but the original number needs to be a negative. I would rather not have to type it as a negative, since I won't always be the one data-entering.

If the status of the first line is "Received" I want to convert my Count box to a negative number. Any ideas?

I know it should be the other way around, but there are quite a few statuses and I think it would be easier to just change it with the one status, rather than a list of them.

Example:
11/1 Received 750
11/2 Processed 200
11/2 Pending 40
11/3 Sent to Duane 10

My running sum should be 500 (the amount left), but it's 1000. Sigh. I've been trying things that don't work for a week. Any help greatly appreciated!

Michelle Hakala

http://www.winebird.com/

 

[randy700]

If the status of the first line is "Received" I want to convert my Count box to a negative number. Any ideas?

Why not simply multiply by -1?


Randy

 

[Hakala]

I KNEW I was missing something easy....

Michelle Hakala

http://www.winebird.com/