When creating a table in MS Access 2007. How do I sum a series of detailed records and assign it a field holder (store the sum) in an Access form?
I have a simple detail table that takes a series of suppliers that send us a commodity and the columns need to be summed.
Suppliers Weights
ACME 1000 lbs
ABC Co 1200 lbs
XYZ Co 1150 lbs
I need the count of suppliers and total weights summary below
3 3350 lbs
I think I need to create a field for each summary ten some how build the formula or expression that will add those up. Is that right and do you have an example in steps of how to do that?
Suppliers Weights
ACME 1000 lbs
ABC Co 1200 lbs
XYZ Co 1150 lbs
I need the count of suppliers and total weights summary below
3 3350 lbs
I think I need to create a field for each summary ten some how build the formula or expression that will add those up. Is that right and do you have an example in steps of how to do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No worries and thanks :)
ASKER