I'm using the expression =Max([Inner Bill Information]![Inner Bill Number])+1 to essentially create a manual autonumber. I have to go back through and restructure my tables, and the Inner Bill Number is not sequential now, but I need it to be once I correct these tables, without losing the old numbers. What's wrong with my code? My field keeps coming back with #Error and I don't have a slightest bit about what I'm doing wrong. The Inner Bill Number field is set to number, so other than that I don't know what else I could change.