This happens to me from time to time. The underlying query in your report is causing an error in Windows that is making Access shut down. Even though the query may be correct, it's just triggering SOMEthing. The way I get around this is create a new database (MDB file), use Get External Data and import everything from the old database into the new one, and try it again in the new MDB. Most of the time, that will work.
Michigan Dept. of Environmental Quality, Air Quality Division