454,316 Members | 2,355 Online
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

 P: n/a 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 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 Would that look like this? =[text13]NZ(Sum([income],0) Sorry but I don't understand how to write this. Don.............. "Salad" 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" 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" wrote in messagenews: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 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" wrote in message news:qt********************************@4ax.com... On Sat, 05 Nov 2005 17:15:32 GMT, "Don" 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" wrote in messagenews: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 #5

 P: n/a On Sun, 06 Nov 2005 12:30:01 GMT, "Don" 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 otherfields.If you don't mind explaining and have the time would you tell me brieflywhat Nz does?Thanks,Don........."Wayne Gillespie" wrote in messagenews:qt********************************@4ax.com.. . On Sat, 05 Nov 2005 17:15:32 GMT, "Don" 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" 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.