473,326 Members | 2,182 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Help with add/subtract

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
5 3078
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Buck Rogers | last post by:
Hi guys! Task 1: Write a program which presents a menu with 5 options. The 5th option quits the program. Each option should execute a system command using system(). Below is my humble...
2
by: mallard134 | last post by:
Could someone please help a newbee vb programmer with a question that is driving me crazy. I am trying to understand a line of code that is supposed to return the domain portion of a valid email...
0
by: Brian Henry | last post by:
Ok I've never implemented a snap location before so I dont really know what im doing wrong here... anyways, I am making a custom slider control that takes dates as its values instead of integers......
13
by: sd00 | last post by:
Hi all, can someone give me some coding help with a problem that *should* be really simple, yet I'm struggling with. I need the difference between 2 times (Target / Actual) However, these times...
1
by: JWest46088 | last post by:
The program asks for the user to enter a real number and an imaginary number followed by another set of a real number and an imaginary number. It then takes those and adds them, subtracts them, and...
0
by: KA NMC | last post by:
Basically what I'm trying to do is - subtract a time field in my record from my system time for each record. Business Days Only example order NO__Name ___Req_date ___Days late ...
10
by: CuTe_Engineer | last post by:
hii, i have cs assignment i tried to solve it but i still have many errors , plzz help mee :"< it`s not cheating becuz i`ve tried & wrote the prog. i just wanna you to show me my mistakes ...
1
by: kalooody | last post by:
#include<iostream> #include<string> using namespace std; class interval { public: void set(int,int);
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.