In a database, created in Access 2007 but in "mdb" format for compatibility, date fields that calculate properly in Report Mode appear as #Error in Print Preview Mode, though they actually print properly. When opened in Access 2003, the same thing happens, and there does not seem to be a Report Mode in 2003 (only Print Preview), and so the complete report cannot be seen on the screen.
Any ideas why this is happening?
Any ideas why this is happening?