I would probably use a union query if there was some reason not to use a calculated field in a report: SELECT Class_Status, Count(Class_Status) as TheCount FROM [ClassesTable] WHERE Class_Date Between #1/1/2007# and #12/31/2008# GROUP BY Class_Status Union SELECT 'All Classes' as Class_Status, Count(*) as TheCount FROM [ClassesTable] WHERE Class_Date Between #1/1/2007# and #12/31/2008#

Scubadriver: Except for the fact that I only need the total once, that's exactly what we need. So I can use DSum to create a calculated field in the same query John designed? Thanks, Robert "scubadiver" wrote: Is this the kind of thing you are after? Completed 15 72 Cancelled 18 72 Resecheduled

Hi John: Thanks for the prompt response. That query works as designed, it gives us the total number of classes for each status. That's what we want, but there's still a problem. I can design a query that gives us the total number of classes during that time frame. Or, I can design a query that gives us the total number of classes for each status, which is the one you designed. However

Hello: tblClasses ----------- I thought designing this query would be easy, but it's turning out to be harder than I anticipated. Obviously I'm doing something wrong. We need to count the number of classes between 2 dates [Class_Date] field. That's the easy part. Then we have to count the number of classes in each category, based on the [Class_Status] field, that were "Completed"