I am getting incorrect summary values in an Access 97 report. I created a basic summary report using the Wizard to start with and customizing from there. I am trying to summarize records by year using the Year builtin function and the totals generated are incorrect and/or do not include all years that should be represented. I've checked the microsoft web site for known problems but didn't find anything. Any ideas?