?
Solved

Sum If in a report

Posted on 2008-06-25
8
Medium Priority
?
892 Views
Last Modified: 2013-11-28
I need to do a basic sum if in Access and I can't figure out how to do it.

I would like to sum [TimeSpent] if PresenterStatusID=1
sum [TimeSpent] if PresenterStatusID=2
sum [TimeSpent] if PresenterStatusID=3
I am just putting them in seperate fields in the report footer
How do I get that to work in a report?

Thanks
0
Comment
Question by:Jennerator
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 75
ID: 21870226
Not quite following the 3 separate conditions ???
0
 

Author Comment

by:Jennerator
ID: 21870250
I think I have figured it out, but essentially what I need to know is if the presenter status is 1 (staff), how much time did then spend and If presenter status 2 (Volunteer) sum thier time seperately and so on. I was tring to do this in a footer, but there is no such thing as a SumIf statement that I know of so instead I am doing seperate if's in the details and then will sum in the footer.

Do you know of a more efficent way to handle this? It seems so basic.
Jenn
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 200 total points
ID: 21870295
"SumIf"

Well, you can do things like this:

=Sum(IIF([FooBar]="Jenn", 1,0) )

so ... each time the field FooBar = "Jenn", it adds 1 to the sum.

Does that help?

btw ... when are you gonna upgrade to a Premium Membership ... ?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Closing Comment

by:Jennerator
ID: 31470786
Doh! That is exaclty what I needed. My brain did not work that way! Thank you.
0
 

Author Comment

by:Jennerator
ID: 21870332
Premium Membership? Where would i find info on that?
0
 
LVL 75
ID: 21870404
Miriam (mbizup) will be along to answer that ... since oddly enough, I can't find it ... lol.

Standby ...

mx

0
 
LVL 75
ID: 21870476
Love that username ....:-)

thx miriam ...

mx
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question