If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating a Total
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 |
#2
|
|||
|
|||
Calculating a Total
I followed another example and did a double query!
"Isaac Sanchez" ! wrote in message ... 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 |
#3
|
|||
|
|||
Calculating a Total
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 wrote: 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 |
#4
|
|||
|
|||
Calculating a Total
Jeff,
You lost me, where/how would I apply that! Isaac "Jeff L" wrote in message oups.com... 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 wrote: 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 |
#5
|
|||
|
|||
Calculating a Total
In a query
Isaac Sanchez wrote: Jeff, You lost me, where/how would I apply that! Isaac "Jeff L" wrote in message oups.com... 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 wrote: 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 |
Thread Tools | |
Display Modes | |
|
|