Functions to = a total field

  • Thread starter Thread starter Leatherplus
  • Start date Start date
L

Leatherplus

I am having trouble getting a total field, This is how I am setting it up
AmountRecieved - AmountSpent = TotalSpent, what am I doing wrong, or rather
what do I need to do and what view do I do it in?
 
I am having trouble getting a total field, This is how I am setting it up
AmountRecieved - AmountSpent = TotalSpent, what am I doing wrong, or rather
what do I need to do and what view do I do it in?
Click to expand...

What's the context?

In a Query you would put

TotalSpent: [AmountReceived] - [AmountSpent]

or if either field might be NULL, use the NZ function to convert null to zero:

TotalSpent: NZ([AmountReceived]) -NZ([AmountSpent])

On a Form or Report you can put

=NZ([AmountReceived]) -NZ([AmountSpent])

in the Control Source property of a textbox.
 
Back
Top