Sum or Total Parts of a Table?

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

Hello. I would like to have a numeric field that I would
like to make the total or sum of a group of numeric
fields... i.e: technicians enter in the total number of
hours worked on a unit, I would like to have the sum of
hours for each unit...

Can anyone help me?

Thanks So Much!

Andrea
 
Hello. I would like to have a numeric field that I would
like to make the total or sum of a group of numeric
fields... i.e: technicians enter in the total number of
hours worked on a unit, I would like to have the sum of
hours for each unit...

Can anyone help me?
Click to expand...

Create a Query based on the table; change it to a Totals query by
clicking the Greek Sigma icon (looks like a sideways M).

Leave the default Group By on the Unit field, and change it to Sum on
the hours field.

You can base a form for onscreen display, or a report for printing, on
this Query; the total should NOT be stored in this or any other table.
 
-----Original Message-----
Hello. I would like to have a numeric field that I would
like to make the total or sum of a group of numeric
fields... i.e: technicians enter in the total number of
hours worked on a unit, I would like to have the sum of
hours for each unit...

Can anyone help me?

Thanks So Much!

Andrea
.
Click to expand...
Hello Andrea,

To Add enter the total number of hours
------------------------------------------------------
To do this you can do it on Table

Step in input data in table
1. double click on the data you made on table
2. clcik on the degisn view
3. enter the data

To add the sum of hours
You must start with a Queries table. If you dont have
one, you must creat a query.


Step in creating a query.
1. click on Queries
2. click on Creat query by using wizard
3. pick the table and field
4. for it has to be the table that has the hours and units
5. select the field
6. next
7. finish
8. then it will open up the query.
9. go to design view , that would be top left below the
files, edit,
10. then look for this icon it look like a letter E, try
to point on it until you see it say totals
11. Once you click on the the letter E, it will make a
Total on the Query.
12 look for Total: Group By
13. click on Group By.
14. Once you click on the Group By it will drop down
15. look for Sum, that will add up the hours in the hours
Field


Khamphout Vincent Au
 
-----Original Message-----
Hello. I would like to have a numeric field that I would
like to make the total or sum of a group of numeric
fields... i.e: technicians enter in the total number of
hours worked on a unit, I would like to have the sum of
hours for each unit...

Can anyone help me?

Thanks So Much!

Andrea
.
Click to expand...
Hello Andrea,

To Add enter the total number of hours
------------------------------------------------------
To do this you can do it on Table

Step in input data in table
1. double click on the data you made on table
2. clcik on the degisn view
3. enter the data

To add the sum of hours
You must start with a Queries table. If you dont have
one, you must creat a query.


Step in creating a query.
1. click on Queries
2. click on Creat query by using wizard
3. pick the table and field
4. for it has to be the table that has the hours and units
5. select the field
6. next
7. finish
8. then it will open up the query.
9. go to design view , that would be top left below the
files, edit,
10. then look for this icon it look like a letter E, try
to point on it until you see it say totals
11. Once you click on the the letter E, it will make a
Total on the Query.
12 look for Total: Group By
13. click on Group By.
14. Once you click on the Group By it will drop down
15. look for Sum, that will add up the hours in the hours
Field


Khamphout Vincent Au
 
-----Original Message-----
Hello. I would like to have a numeric field that I would
like to make the total or sum of a group of numeric
fields... i.e: technicians enter in the total number of
hours worked on a unit, I would like to have the sum of
hours for each unit...

Can anyone help me?

Thanks So Much!

Andrea
.
Click to expand...
Hello Andrea,

To Add enter the total number of hours
------------------------------------------------------
To do this you can do it on Table

Step in input data in table
1. double click on the data you made on table
2. clcik on the degisn view
3. enter the data

To add the sum of hours
You must start with a Queries table. If you dont have
one, you must creat a query.


Step in creating a query.
1. click on Queries
2. click on Creat query by using wizard
3. pick the table and field
4. for it has to be the table that has the hours and units
5. select the field
6. next
7. finish
8. then it will open up the query.
9. go to design view , that would be top left below the
files, edit,
10. then look for this icon it look like a letter E, try
to point on it until you see it say totals
11. Once you click on the the letter E, it will make a
Total on the Query.
12 look for Total: Group By
13. click on Group By.
14. Once you click on the Group By it will drop down
15. look for Sum, that will add up the hours in the hours
Field


Khamphout Vincent Au
 
Back
Top