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.
My database has tables for sales and for locations. The report uses a query to retrieve sales for the dates input.
