Results 1 to 3 of 3
  1. #1
    eddyc99 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2009
    Posts
    2

    Auto Sequence String Serial Number

    I'm looking for a solution to create a public variable that when called in a query will automatically assign the last serial number +1, but the query may pull more than one item without a serial number. The serial number is comprised of letters and numbers only.
    I'm stumped !!


    Thanks in advance for any help.

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Can you share with us the logic behind this and if possible a clear example of what you have and what you want.

    David

  3. #3
    eddyc99 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2009
    Posts
    2
    Thanks David,
    I have two tables, one (table1) is a complete list of all items with serial numbers (ABC4000001,ABC4000002....ABC5000102). The other table (table2) has some records that exist in table1 but also some new items which do not have serial numbers that I would like to append to table1. I would like append more than one record a time using an append query if possible and at the same time assign a serial number sequenced on the latest serial number.
    For example, the new items below were missing a serial number (s/n) but the query would generate the assigned s/n and append to table1.
    new item assigned s/n
    XTA ABC5000103
    XTB ABC5000104
    XTC ABC5000105
    XT4 ABC5000106
    XT1 ABC5000107
    I hope I was able to clear up my question a bit. Thanks again!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Auto Number in Query
    By Alex Motilal in forum Programming
    Replies: 1
    Last Post: 09-21-2009, 07:17 AM
  2. Restart auto number after deleting records
    By P5C768 in forum Database Design
    Replies: 1
    Last Post: 09-11-2009, 02:07 PM
  3. How do I find the serial value of Now()?
    By JoeG in forum Queries
    Replies: 0
    Last Post: 03-13-2007, 08:16 AM
  4. Need help with an auto number
    By Wrangler in forum Database Design
    Replies: 1
    Last Post: 02-10-2006, 03:21 PM
  5. Replies: 5
    Last Post: 02-08-2006, 08:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums