How can I addition a quantity in a text box

F

Fred's

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
 
F

fredg

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).
 
K

Klatuu

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 said:
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).
 
F

Fred's

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



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).

- 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
 
K

Klatuu

Sorry, it was a typo. Correct syntax is
=Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo])

--
Dave Hargis, Microsoft Access MVP


Fred's said:
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 said:
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.

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).

- 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
 
F

Fred's

Sorry, it was a typo. Correct syntax is
=Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo])

--
Dave Hargis, Microsoft Access MVP



Fred's said:
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
:
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
 
F

Fred's

Sorry, it was a typo. Correct syntax is
=Nz([Aldo]) + Nz([FeetFirst]) + Nz([Transit]) + Nz([Globo])

--
Dave Hargis, Microsoft Access MVP



Fred's said:
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
:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top