I have a rather complex report to build for my db. The question I have is can I do a count based on certain criteria. What i have is a report based on a query that shows all the delegates that have been scheduled onto events. Each delegate has a status concerning their attendance or non attendance for the course. I have grouped the report based on date first by month and then grouped on coursename (each event belongs to a coursename). This is fine but now I need to count all the delegates who have a status of either 4 or 5 and also those with a status of 6 or 7 for each event and show both these separately at the end of the report (or maybe for each month but the solution will do for each I think). Then I need to count all the delegates who have a status of the above for all the courses and finally the same but by their department (each delegate belongs to a department). I have tried various count statements in control sources including =Count([Status]=6 or 7) and Sum([Status=6 or 7]) but they both add all up all the records whatever their status. Is this possible to do it this way or will I have to do something else (I'm a newcomer to reports so it's all a bit alien)
Thanks to anyone who can help or point me to where to look