SUM IN REPORT

[Fred's]

Hello folks,

I've have the following

A table called: "TBL_CEDULE" with the fields names: Index, TIME,
TRANSPORTEUR OU CONTAINER, SEAL#, DOOR#, SHOES, ALDO, FEETFIRST,
TRANSIT, GLOBO, HANDBAGS, ALDO1, NONALDO, ACCESSORIES, ALDO2,
NONALDO1.

A report based on the table, and in the detail section of the report I
have the following text boxes: SHOES, HANDBAGS, ACCESSORIES which I
will like to have a formula that calculate the sum of the quantity
entered in the previous fields.

For example:

If I enter 100 in "ALDO" , 100 in "FEETFIRST", 100 in "TRANSIT" and
100 in "GLOBO", I want that the text box which the name is "SHOES"
indicates a sum of "400"

Thanking you in advance for your help!

Fred's

 

[Tony Williams]

Fred you need to change the source of the control SHOES to;
=[ALDO]+[FEETFIRST]+[TRANSIT]+[GLOBAL]
assuming the four fields are numbers
Don't forget the = sign
HTH
Tony

 

[Pat Hartman]

In addition, if any of the fields might be null, you will need to account
for that in your calculation.
=Nz([ALDO],0) + Nz([FEETFIRST],0) + Nz([TRANSIT],0) + Nz([GLOBAL],0)
Domain functions handle nulls properly but expressions don't.

Fred you need to change the source of the control SHOES to;
=[ALDO]+[FEETFIRST]+[TRANSIT]+[GLOBAL]
assuming the four fields are numbers
Don't forget the = sign
HTH
Tony

Hello folks,

I've have the following

A table called: "TBL_CEDULE" with the fields names: Index, TIME,
TRANSPORTEUR OU CONTAINER, SEAL#, DOOR#, SHOES, ALDO, FEETFIRST,
TRANSIT, GLOBO, HANDBAGS, ALDO1, NONALDO, ACCESSORIES, ALDO2,
NONALDO1.

A report based on the table, and in the detail section of the report I
have the following text boxes: SHOES, HANDBAGS, ACCESSORIES which I
will like to have a formula that calculate the sum of the quantity
entered in the previous fields.

For example:

If I enter 100 in "ALDO" , 100 in "FEETFIRST", 100 in "TRANSIT" and
100 in "GLOBO", I want that the text box which the name is "SHOES"
indicates a sum of "400"

Thanking you in advance for your help!

Fred's