Search results

  1. P

    Count and Sum query

    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...
  2. P

    Select statement w/varying criteria

    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...
  3. P

    Date range for report

    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...
Back
Top Bottom