Hi Andrew,

Reread Steve's last paragraph. I think you're saying the same thing except that Steve is pointing out that when a department is added within the previously selected range, it doesn't show that new department in the totals.

Just like the .Range command on the statement, a departmental range should include any newly created departments that fall within that range.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON