By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

Help with add/subtract

P: n/a
Don
I have a report that among other things has two text boxes. One reports the
sum of charges, the other reports those charges minus any payments made
against the charges (balance due). The problem I have is the text box that
reports the balance due will not show anything until an entry is made into
the payments field. In other words if the sum of charges is $100.00 and
nothing has been paid against that the "balance due" field is blank, instead
of showing $100.00.
I can't seem to make it do this, can anyone help?
Here's what I've got in the properties for the "balance due". Sum of
Charges = text13, Balance due = Income.
=[text13]-Sum([income])
Thanks,
Don..........
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Don wrote:
I have a report that among other things has two text boxes. One reports the
sum of charges, the other reports those charges minus any payments made
against the charges (balance due). The problem I have is the text box that
reports the balance due will not show anything until an entry is made into
the payments field. In other words if the sum of charges is $100.00 and
nothing has been paid against that the "balance due" field is blank, instead
of showing $100.00.
I can't seem to make it do this, can anyone help?
Here's what I've got in the properties for the "balance due". Sum of
Charges = text13, Balance due = Income.
=[text13]-Sum([income])
Thanks,
Don..........

See if using NZ assists. Ex:
NZ(Sum([income],0)
Nov 13 '05 #2

P: n/a
Don
Would that look like this?
=[text13]NZ(Sum([income],0)
Sorry but I don't understand how to write this.
Don..............
"Salad" <oi*@vinegar.com> wrote in message
news:6m**************@newsread1.news.pas.earthlink .net...
Don wrote:
I have a report that among other things has two text boxes. One reports the sum of charges, the other reports those charges minus any payments made
against the charges (balance due). The problem I have is the text box that reports the balance due will not show anything until an entry is made into the payments field. In other words if the sum of charges is $100.00 and
nothing has been paid against that the "balance due" field is blank, instead of showing $100.00.
I can't seem to make it do this, can anyone help?
Here's what I've got in the properties for the "balance due". Sum of
Charges = text13, Balance due = Income.
=[text13]-Sum([income])
Thanks,
Don..........

See if using NZ assists. Ex:
NZ(Sum([income],0)

Nov 13 '05 #3

P: n/a
On Sat, 05 Nov 2005 17:15:32 GMT, "Don" <vz******@verizon.net> wrote:

=[Text13]-Sum(Nz([Income],0))
Would that look like this?
=[text13]NZ(Sum([income],0)
Sorry but I don't understand how to write this.
Don..............
"Salad" <oi*@vinegar.com> wrote in message
news:6m**************@newsread1.news.pas.earthlin k.net...
Don wrote:
> I have a report that among other things has two text boxes. One reportsthe > sum of charges, the other reports those charges minus any payments made
> against the charges (balance due). The problem I have is the text boxthat > reports the balance due will not show anything until an entry is madeinto > the payments field. In other words if the sum of charges is $100.00 and
> nothing has been paid against that the "balance due" field is blank,instead > of showing $100.00.
> I can't seem to make it do this, can anyone help?
> Here's what I've got in the properties for the "balance due". Sum of
> Charges = text13, Balance due = Income.
> =[text13]-Sum([income])
> Thanks,
> Don..........
>
>

See if using NZ assists. Ex:
NZ(Sum([income],0)


Nov 13 '05 #4

P: n/a
Don
Thank you. It works and I've been able to put it into a couple of other
fields.
If you don't mind explaining and have the time would you tell me briefly
what Nz does?
Thanks,
Don.........
"Wayne Gillespie" <be*****@NOhotmailSPAM.com.au> wrote in message
news:qt********************************@4ax.com...
On Sat, 05 Nov 2005 17:15:32 GMT, "Don" <vz******@verizon.net> wrote:

=[Text13]-Sum(Nz([Income],0))
Would that look like this?
=[text13]NZ(Sum([income],0)
Sorry but I don't understand how to write this.
Don..............
"Salad" <oi*@vinegar.com> wrote in message
news:6m**************@newsread1.news.pas.earthlin k.net...
Don wrote:
> I have a report that among other things has two text boxes. One reports
the
> sum of charges, the other reports those charges minus any payments
made > against the charges (balance due). The problem I have is the text boxthat
> reports the balance due will not show anything until an entry is made

into
> the payments field. In other words if the sum of charges is $100.00

and > nothing has been paid against that the "balance due" field is blank,

instead
> of showing $100.00.
> I can't seem to make it do this, can anyone help?
> Here's what I've got in the properties for the "balance due". Sum of > Charges = text13, Balance due = Income.
> =[text13]-Sum([income])
> Thanks,
> Don..........
>
>
See if using NZ assists. Ex:
NZ(Sum([income],0)

Nov 13 '05 #5

P: n/a
On Sun, 06 Nov 2005 12:30:01 GMT, "Don" <vz******@verizon.net> wrote:

The Nz function converts a Null value into the value specified by the second argument in this case 0.
A Null value cannot be included in a general maths equation as it has no value, so by converting the value to 0 it
allows the equation to be calculated.
Thank you. It works and I've been able to put it into a couple of other
fields.
If you don't mind explaining and have the time would you tell me briefly
what Nz does?
Thanks,
Don.........
"Wayne Gillespie" <be*****@NOhotmailSPAM.com.au> wrote in message
news:qt********************************@4ax.com.. .
On Sat, 05 Nov 2005 17:15:32 GMT, "Don" <vz******@verizon.net> wrote:

=[Text13]-Sum(Nz([Income],0))
>Would that look like this?
>=[text13]NZ(Sum([income],0)
>Sorry but I don't understand how to write this.
>Don..............
>"Salad" <oi*@vinegar.com> wrote in message
>news:6m**************@newsread1.news.pas.earthlin k.net...
>> Don wrote:
>> > I have a report that among other things has two text boxes. Onereports >the
>> > sum of charges, the other reports those charges minus any paymentsmade >> > against the charges (balance due). The problem I have is the textbox >that
>> > reports the balance due will not show anything until an entry is made
>into
>> > the payments field. In other words if the sum of charges is $100.00and >> > nothing has been paid against that the "balance due" field is blank,
>instead
>> > of showing $100.00.
>> > I can't seem to make it do this, can anyone help?
>> > Here's what I've got in the properties for the "balance due". Sumof >> > Charges = text13, Balance due = Income.
>> > =[text13]-Sum([income])
>> > Thanks,
>> > Don..........
>> >
>> >
>> See if using NZ assists. Ex:
>> NZ(Sum([income],0)
>


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.