I am working with a 2003 database with Access 2010. I have a main report with both detail and total information (calculated fields) plus two sub-reports. The first sub-report retreives and summarizes data using a separate query while the second sub-report is a summary report that adds the totals generated by the main report and the first sub-report together. Everything works great in report mode, but fails to display the first sub-report nor generate the summary totals in preview mode if the first sub-report returns no data (which quite offen happens). How do I display the first sub-report and update my summary totals (the second sub-report) in preview mode so that I might print the entire report? Hope this all makes sense!
Thank you very much for any help you might have.....