I have an inventory database. The key is the 'page' number the goods came in on. It's a 3 digit number. At the end of the last fiscal year, the CFO decided that instead of expanding the field to 4 digits, as the last 'page' was 977, he wanted to restart the count at 100. All goes well except when I now run the end of the month inventory, and within the report query is sum function, it does the math perfectly well for any goods still in inventory for pages up to 977, but does the math wrong on the pages starting with 100. Is there any explanation you can think of?