I have an Access report that I have set up to give me contest entries totals by district. I worked as of March 5 as I am looking at the hard copy report. The database is copied each year and I update the database name and tables. I started adding more entries to the main database and now the report does not work. When I pull up the report, all I get is blanks where it would normally have numbers for District 1, District 2, etc. I am stumped. I even resaved it again, deleted the information and started over. I am stumped! The report pulls from sum of queries which are blank. The essay contest total by district queries have the totals but not the sum of the total queries so they can pull it in the report. I hope I am not confusing anyone but I am not that savvy with Access and hope someone understands. Don't know if I am able to attach a copy of the database if that would be helpful to anyone, but thought I'd give this forum a shot. I checked back to the 2014 database and it all seems the same so can't tell what is wrong with the queries or report. I have District 1 - District 11. four districts don't have any totals yet. The total all districts query that this report is attached to is blank. The numbers that should be in each district (like the one below) should be in the total all districts query for the report but all fields are blank whether they have totals in them or not. But all total districts (with the exception of 4) have numbers in them like the one below.
SumOfSchool Total District 2 37 x