F
Fred's
Hi folks, hope that someone can help me with my problem:
I've build a table called: "Cedule_Tbl" and I've build a form with it,
called "Form1". in my table, I have the following field names and
datatype. (I didn't put any primary key to my table)
Field names: Data Type:
ID AutoNumber
Heure Date/Time
TransporteurOuRemorque Text
Seal Text
Porte Text
Footwear Number
ALDO Number
Feet-First Number
Transit Number
Globo Number
Handbags Number
ALDO/ Number
NonALDO Number
Accesories Number
ALDO1 Number
NonALDO1 Number
On my form, I need to have the following sum.
PS. The data in the datatype is numbers that represent quantity of
cartons.
I bear you, what are the formulas, I'm a worst than a beginner in this
matter;
A Total sum of cartons for the merchandise type (Footwear), the sum
must come from the sum of units (ALDO +Feet-First +Transit +Globo )
A Total sum of cartons for the merchandise type (Handbag), the sum
must come from the sum of units (ALDO/ +NonALDO)
A Total sum of cartons for the merchandise type (Accesories), the sum
must come from the sum of units (ALDO1/ +NonALDO1)
A Grand Total sum of cartons for the each merchandise type (Footwear,
handbag and accesories).
And the Grand Grand total of cartons to received.
Thanking you all in advance for your help and support.
Fred's
I've build a table called: "Cedule_Tbl" and I've build a form with it,
called "Form1". in my table, I have the following field names and
datatype. (I didn't put any primary key to my table)
Field names: Data Type:
ID AutoNumber
Heure Date/Time
TransporteurOuRemorque Text
Seal Text
Porte Text
Footwear Number
ALDO Number
Feet-First Number
Transit Number
Globo Number
Handbags Number
ALDO/ Number
NonALDO Number
Accesories Number
ALDO1 Number
NonALDO1 Number
On my form, I need to have the following sum.
PS. The data in the datatype is numbers that represent quantity of
cartons.
I bear you, what are the formulas, I'm a worst than a beginner in this
matter;
A Total sum of cartons for the merchandise type (Footwear), the sum
must come from the sum of units (ALDO +Feet-First +Transit +Globo )
A Total sum of cartons for the merchandise type (Handbag), the sum
must come from the sum of units (ALDO/ +NonALDO)
A Total sum of cartons for the merchandise type (Accesories), the sum
must come from the sum of units (ALDO1/ +NonALDO1)
A Grand Total sum of cartons for the each merchandise type (Footwear,
handbag and accesories).
And the Grand Grand total of cartons to received.
Thanking you all in advance for your help and support.
Fred's