If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I addition a quantity in a text box
Hi,
How can I addition a quantity in a text box (unbound control box) which is in the section of detail of the report. My report bounds to a table. Here are the header field names, and the info entered in these field names are numbers. ALDO FEETFIRST TRANSIT GLOBO |
#2
|
|||
|
|||
How can I addition a quantity in a text box
On Mon, 29 Oct 2007 15:56:48 -0700, Fred's wrote:
Hi, How can I addition a quantity in a text box (unbound control box) which is in the section of detail of the report. My report bounds to a table. Here are the header field names, and the info entered in these field names are numbers. ALDO FEETFIRST TRANSIT GLOBO These fields all contain number values? You wish to add them all together? In an unbound text control on the report: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) The Nz() is needed in case one of the fields contains no data (Is Null). -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
How can I addition a quantity in a text box
fredg,
As written, all nulls will be converted to a Null string "" Should be: =[Nz([Aldo],0) + Nz([FeetFirst],0) + Nz([Transit],0) + Nz([Globo],0) -- Dave Hargis, Microsoft Access MVP "fredg" wrote: On Mon, 29 Oct 2007 15:56:48 -0700, Fred's wrote: Hi, How can I addition a quantity in a text box (unbound control box) which is in the section of detail of the report. My report bounds to a table. Here are the header field names, and the info entered in these field names are numbers. ALDO FEETFIRST TRANSIT GLOBO These fields all contain number values? You wish to add them all together? In an unbound text control on the report: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) The Nz() is needed in case one of the fields contains no data (Is Null). -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
How can I addition a quantity in a text box
On Oct 30, 1:51 pm, Klatuu wrote:
fredg, As written, all nulls will be converted to a Null string "" Should be: =[Nz([Aldo],0) + Nz([FeetFirst],0) + Nz([Transit],0) + Nz([Globo],0) -- Dave Hargis, Microsoft Access MVP "fredg" wrote: On Mon, 29 Oct 2007 15:56:48 -0700, Fred's wrote: Hi, How can I addition a quantity in a text box (unbound control box) which is in the section of detail of the report. My report bounds to a table. Here are the header field names, and the info entered in these field names are numbers. ALDO FEETFIRST TRANSIT GLOBO These fields all contain number values? You wish to add them all together? In an unbound text control on the report: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) The Nz() is needed in case one of the fields contains no data (Is Null). -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail- Hide quoted text - - Show quoted text - Hi, when I enter your formla: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) the access help tell me that there are to manya brackets? Any other idea! Thank you, Fred's |
#5
|
|||
|
|||
How can I addition a quantity in a text box
Sorry, it was a typo. Correct syntax is
=Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) -- Dave Hargis, Microsoft Access MVP "Fred's" wrote: On Oct 30, 1:51 pm, Klatuu wrote: fredg, As written, all nulls will be converted to a Null string "" Should be: =[Nz([Aldo],0) + Nz([FeetFirst],0) + Nz([Transit],0) + Nz([Globo],0) -- Dave Hargis, Microsoft Access MVP "fredg" wrote: On Mon, 29 Oct 2007 15:56:48 -0700, Fred's wrote: Hi, How can I addition a quantity in a text box (unbound control box) which is in the section of detail of the report. My report bounds to a table. Here are the header field names, and the info entered in these field names are numbers. ALDO FEETFIRST TRANSIT GLOBO These fields all contain number values? You wish to add them all together? In an unbound text control on the report: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) The Nz() is needed in case one of the fields contains no data (Is Null). -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail- Hide quoted text - - Show quoted text - Hi, when I enter your formla: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) the access help tell me that there are to manya brackets? Any other idea! Thank you, Fred's |
#6
|
|||
|
|||
How can I addition a quantity in a text box
On Oct 31, 1:20 pm, Klatuu wrote:
Sorry, it was a typo. Correct syntax is =Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) -- Dave Hargis, Microsoft Access MVP "Fred's" wrote: On Oct 30, 1:51 pm, Klatuu wrote: fredg, As written, all nulls will be converted to a Null string "" Should be: =[Nz([Aldo],0) + Nz([FeetFirst],0) + Nz([Transit],0) + Nz([Globo],0) -- Dave Hargis, Microsoft Access MVP "fredg" wrote: On Mon, 29 Oct 2007 15:56:48 -0700, Fred's wrote: Hi, How can I addition a quantity in a text box (unbound control box) which is in the section of detail of the report. My report bounds to a table. Here are the header field names, and the info entered in these field names are numbers. ALDO FEETFIRST TRANSIT GLOBO These fields all contain number values? You wish to add them all together? In an unbound text control on the report: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) The Nz() is needed in case one of the fields contains no data (Is Null). -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail- Hide quoted text - - Show quoted text - Hi, when I enter your formla: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) the access help tell me that there are to manya brackets? Any other idea! Thank you, Fred's- Hide quoted text - - Show quoted text - Tha |
#7
|
|||
|
|||
How can I addition a quantity in a text box
On Oct 31, 1:20 pm, Klatuu wrote:
Sorry, it was a typo. Correct syntax is =Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) -- Dave Hargis, Microsoft Access MVP "Fred's" wrote: On Oct 30, 1:51 pm, Klatuu wrote: fredg, As written, all nulls will be converted to a Null string "" Should be: =[Nz([Aldo],0) + Nz([FeetFirst],0) + Nz([Transit],0) + Nz([Globo],0) -- Dave Hargis, Microsoft Access MVP "fredg" wrote: On Mon, 29 Oct 2007 15:56:48 -0700, Fred's wrote: Hi, How can I addition a quantity in a text box (unbound control box) which is in the section of detail of the report. My report bounds to a table. Here are the header field names, and the info entered in these field names are numbers. ALDO FEETFIRST TRANSIT GLOBO These fields all contain number values? You wish to add them all together? In an unbound text control on the report: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) The Nz() is needed in case one of the fields contains no data (Is Null). -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail- Hide quoted text - - Show quoted text - Hi, when I enter your formla: =[Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo]) the access help tell me that there are to manya brackets? Any other idea! Thank you, Fred's- Hide quoted text - - Show quoted text - Hi Dave, thank you, I forgot to ask you something else, Once the total of your formula appear, If I want a Grand total of it, what will be the formula? Thank you, Fred's |
Thread Tools | |
Display Modes | |
|
|