Calculating a Total

[Isaac Sanchez]

How Ya'll Doin'!!
How would I calculate a total of some of the rows in a column!!
I have a table:
Week Route Stop # Box Count Weight
45 A 1 5 50
45 A 2 10 100
45 B 1 15 150
45 B 2 20 200
45 C 1 25 250
45 C 1 30 300

I want to calculate the Box Count and Weight for each Route!
How would I do this with in a form?
Put some code behind a command button?

Thanks In Advance
Isaac Sanchez

 

[Isaac Sanchez]

I followed another example and did a double query!

 

[Jeff L]

To get the box count and weight for each route:

Select Week, Route, Sum([Box Count]), Sum(Weight)

From YourTable

Group by Week, Route

Hope that helps!

 

[Isaac Sanchez]

Jeff,
You lost me, where/how would I apply that!
Isaac

To get the box count and weight for each route:

Select Week, Route, Sum([Box Count]), Sum(Weight)

From YourTable

Group by Week, Route

Hope that helps!

How Ya'll Doin'!!
How would I calculate a total of some of the rows in a column!!
I have a table:
Week Route Stop # Box Count Weight
45 A 1 5 50
45 A 2 10 100
45 B 1 15 150
45 B 2 20 200
45 C 1 25 250
45 C 1 30 300

I want to calculate the Box Count and Weight for each Route!
How would I do this with in a form?
Put some code behind a command button?

Thanks In Advance
Isaac Sanchez

 

[Jeff L]

In a query

Jeff,
You lost me, where/how would I apply that!
Isaac

To get the box count and weight for each route:

Select Week, Route, Sum([Box Count]), Sum(Weight)

From YourTable

Group by Week, Route

Hope that helps!

How Ya'll Doin'!!
How would I calculate a total of some of the rows in a column!!
I have a table:
Week Route Stop # Box Count Weight
45 A 1 5 50
45 A 2 10 100
45 B 1 15 150
45 B 2 20 200
45 C 1 25 250
45 C 1 30 300

I want to calculate the Box Count and Weight for each Route!
How would I do this with in a form?
Put some code behind a command button?

Thanks In Advance
Isaac Sanchez