Probably easy SUM question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Sharepoint and Access.
I have pulled an access dbase from it that includes a list of all of the
locations and number of hours spent at each for a class. So I might have 100
entries from location A, 25 from location B, 0 from location c, and each
entry has a number of hours.

So what it would look like in the dbase is
Location A, 3hrs
Location A, 2hrs
Location A, 5hrs

Location B, 2hrs
Location B, 0hrs
Location B, 9hrs

Location C, 0hrs

What I need is a report that only shows
location A 10 hrs
location B 11hrs
location C 0

Sounds so simple (=SUM([hours]) but I am not having much luck. I am sure
it's so obvious that I am just missing it , any idea's?
 
Jim said:
Using Sharepoint and Access.
I have pulled an access dbase from it that includes a list of all of the
locations and number of hours spent at each for a class. So I might have 100
entries from location A, 25 from location B, 0 from location c, and each
entry has a number of hours.

So what it would look like in the dbase is
Location A, 3hrs
Location A, 2hrs
Location A, 5hrs

Location B, 2hrs
Location B, 0hrs
Location B, 9hrs

Location C, 0hrs

What I need is a report that only shows
location A 10 hrs
location B 11hrs
location C 0

Sounds so simple (=SUM([hours]) but I am not having much luck. I am sure
it's so obvious that I am just missing it , any idea's?
Click to expand...


Unless you actually have the "hrs" in the hours field, Sum
should do this. If the "hrs" is in the field, then try
using:
=Sum(Val(hours))
 
Back
Top