Totals for a Database

R

Rick

I have a database and one of the fields is 'cable_length'. The only thing
that I am trying to do is get the total length of cable that I have used on a
project (add the cable lenghts for all the records in the database).
I have tried using 'total' and 'sum' but I may be doing something wrong as
it did not add them all together.
I know it's something simple but I can't figure it out right now.

Access 2003 Professional on XP
 
S

Sharkbyte

When you say "Add the length for all records in the database", I am assuming
that this db is for tracking this single project. Because the answer is
different, if it is not...

So, with that said:
Create a query
Add the table you want, and select the field you want to total (Cable_length)
Click the Totals button (the funny E)
Change Group By (in the query design area) to be sum
View your results
Click to expand...

If you have more than one project, I will assume you have some project
identifier in the same table with Cable_length. So, in this case, add
whatever the project identifier field is, to the query, but leave its option
as Group By. Now you will see total Cable usage, by project.

HTH

Sharkbyte
 
Top