I currently have a report that shows sales by location for given dates with totals by location. My problem comes when a location has no sales for the period entered. It currently skips that location with no heading. I would like to show the location and show zero sales for the total. There maybe an easy work around but I can't think of it. Any suggestions?

My database has tables for sales and for locations. The report uses a query to retrieve sales for the dates input.

Modify your query so that it includes the Location table. Add the location table all the way to the left in the grid and join it to the primary table. Change the join type to Left so that all records from location will be included even if they have no corresponding data in the other tables.