Results 1 to 2 of 2
  1. #1
    lizzywu is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011

    To generate sequential numbers in query

    Hi there,

    I am not good at coding or programming at all, but I'm trying to learn. My question might be easy to you.

    I try to generate a sequence of number based in my query q_count (as attached) like AS-2011-****, where **** is the subject_id I had in my tables and query. Can anyone teach me how to do that?

    Thank you very much.
    Attached Files Attached Files

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    subject_id is not in your table.

    Why do you want this scheme?
    This site may give you more info

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

Similar Threads

  1. Replies: 8
    Last Post: 01-13-2012, 08:20 AM
  2. Replies: 11
    Last Post: 07-14-2011, 03:03 PM
  3. How to add sequential numbers to query resultset
    By h_latha2k in forum Queries
    Replies: 3
    Last Post: 04-29-2011, 08:53 PM
  4. Replies: 3
    Last Post: 10-18-2009, 08:38 PM
  5. Replies: 1
    Last Post: 01-31-2009, 10:43 AM

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 - Senior Forums