I have a client who has a database with large numbers, up to 100 billion - and desires reports rounded to the nearest million. <br><br>This report is sorted by agents and datafields are listed in the detail section of the report in billions - where they want to round by millions, divide by 1000, or multiply by .001. I've tried everything, even some examples shown in books and only get a "#Error".<br><br>Any suggestions, recommendations, or work arounds would be appreciated,<br><br>JWJ