I have a database with the fields BusNumber, Yard, Location, Status, KnownIssues.. I would like to show in a report the status of the bus (there are three options 1. In Service, 2. Operational - Needs Work and 3. Out of Service. I would just like a total of the busses that have the status In Service Grouped by Yard and Location (Yard is where bus is parked and Location is School it is assigned to). We manage school bus transportation services. In the same report I need to show all the other columns. I have created the report with all the data and the Status field I was able to create a "Variable" that would suposedly calculate the total number of busses with the status In Service, however it is only counting it per line, not per location or per yard. How do i group the calculations to say not only do I want it to COUNT(Status)="In Service" but also to Group the results by Yard, Location?? I have tried sub reports, several other query options, and nothing seems to work to get all the data as I want it on the same page. See below. The In Serv Count column is not totalling by Yard, or Location. HELP IS APPRECIATED.