We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
I should totally know this, but for some reason I can't seem to make it work today.
I have a yes/no for Program and a Yes/No for Reception. I have a separate number of tickets field. I need counts for the program and the reception.
For argument's sake, let's assume that there aren't separate counts for these things. So I need to sum number of tickets if Program = Yes, and separately I need to sum number of tickets if Reception = yes. How do I do this?
If you are using MS Access you would make a query that is a sum query (backwards E thingy). Use Group by ticket type, count for ticket type, and then Where the Yes/no field = yes.
__________________ Andrea Shlasko
Database Manager
Big Brothers Big Sisters of the Sun Coast Inc.
"Just another day in Paradise, where every meal's a banquet and every day's a holiday"
I see where you're going with that, but I need this in a report that has the other stuff too. Is there a way to conditionally sum a field in a report without pulling a separate query?
Like, I have the total sum of the number of tickets up top, and a list of attendees of the whole event, and I just want separate little sums of program and reception.
Sorry to ask this here, it's not even really RE related, really.
I see where you're going with that, but I need this in a report that has the other stuff too. Is there a way to conditionally sum a field in a report without pulling a separate query?
Like, I have the total sum of the number of tickets up top, and a list of attendees of the whole event, and I just want separate little sums of program and reception.
Sorry to ask this here, it's not even really RE related, really.
Do you need details above your sums or just sums?
Also, the bus has many routes that it takes and Microsoft OFFICE is traveled many many many...times
__________________ Elaine Tucker Stewardship Coordinator St. Mark's School of Texas USA www.smtexas.org
Location: I live in Western New York, a few thousand miles from my homeland, Costa Rica.
Posts: 5
Rep Power: 0
I think that you can just do an IFF statement if you can do a SUM; however, if you need to do a Count, then you might need a separate little query to do this for you. I have run into trouble when counting with an Iff statement in Access. If you turn all your "yes" into "1", then a Sum should work. Your IFF statement should be something along the lines of Sum(Iff([reception field]=1,[reception field])).
__________________ Olga Gonzalez Nichols
Development Manager
Buffalo Olmsted Parks Conservancy
Buffalo NY 14214
Linear Mode
