Recent content by pwilly

I actually just got what I needed from another forum. Thanks to pbaldy for responding! Here is the resolution in case anyone's interested: SELECT ClassName , COUNT(*) AS [Total # of Classes] , SUM(IIf(AgeOfParticipants=1,NumberOfParticipants,NULL)) AS [# for Children] ...

The problem is that I need to return the sum of a field called NumberOfParticipants which is a number field. So for instance this field may contain 12 children in class A that took place 2 weeks ago in one record, 6 children in class B a week ago in the next record and 23 youth in class A a week...

I am seeking help with creating a query that will return the total number of classes, total number of classes broken down by age group, total number of participants for each class and total number of participants for each class broken down by age group. I seem to have everything except the total...

1. SELECT interview.location, Count(interview.location) AS [Total # of events], Count(IIF(interview.AgeOfParticipants=1,1,NULL)) AS [# for Youth], Count(IIF(interview.AgeofParticipants=2,1,NULL)) AS [# for Adults], SUM(interview.NumberOfkiosks), SUM(interview.NumberOfParticipants), 2. (SELECT...

I have created a database in Access 2000 file format that tracks something similar to helpdesk calls. I need a report that will display all of the new calls opened and all of the calls closed within a 6 month period. This report will be ran from now on, twice a year covering Jan to the end of...