How can I addition a quantity in a text box

[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

 

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

 

[Guest]

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

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

 

[Guest]

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

--
Dave Hargis, Microsoft Access MVP

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

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

 

[Fred's]

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

--
Dave Hargis, Microsoft Access MVP

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

 

[Fred's]

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

--
Dave Hargis, Microsoft Access MVP

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