Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    35

    Unanswered: Manual Autonumber?

    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.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I suspect you want a DMax:

    General: DLookup Usage Samples
    Paul

  3. #3
    Join Date
    Oct 2008
    Posts
    35
    Thank you kind sir, as your suspicions were correct!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •