|
| 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
November 10th, 2006, 02:07 PM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
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
November 10th, 2006, 02:28 PM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
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
November 10th, 2006, 07:39 PM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
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
November 10th, 2006, 08:52 PM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
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
November 10th, 2006, 09:10 PM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
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 | |
|
|
Linear Mode
