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

    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
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    subject_id is not in your table.

    Why do you want this scheme?
    This site may give you more info http://www.techonthenet.com/access/m...ntial_nbr2.php

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