Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Question Unanswered: Complex incremental numbering problem

    The Setting:
    I have amended an examination databases main table "All_persons" to include all previous applicants/candidates to the tests so their info. doesn't need to be re-entered for future applications.
    The secretary's just need to tick the "2005 Applicants", which is filtered in a query and feed to the "all_enquires" form which is used to update the info. and add new applicants.

    The Problem:
    We need a unique & incremental reference number for each 2005 Applicant. I can't just use an AutoNumber field in the main table as it will number non-2005 Applicants. I've also tried =Nz(DMax("[id]","All_persons"),0)+1 in an "id" field in the form which works for any new entries but not for previous applicants re-entering (as they already exist in the main table). Any thoughts?

    Help I'm a newbie! (and Access isn't my day-job!)

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You're making this WAY to complicated

    Just track the date the record was entered.

    Also, elaborate on "the tests". I have no clue what that is.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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