Results 1 to 12 of 12
  1. #1
    jamil_kwi is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    8

    Automatic Serial Number in Report

    Hi Freinds,

    I need some help from you. I have a report with Employee Name data and I want autometic serial number with every record. like below

    Sr. No. Employee Name
    1 John


    2 Smith
    3 Ellen
    4 Chris
    5 Tommy

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    put an unbound text box on the report. Go to its properties. In the control source put =1. Then in the Running Sum select over all. This will do the needful. Please mark the thread solved if this solves your problem.

  3. #3
    jamil_kwi is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    8
    Thanks Maximus....
    It is woking....


    Regards,
    Jamil

  4. #4
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    mark the thread solved my friend

  5. #5
    Join Date
    May 2011
    Posts
    1

    Smile Auto Serial Number generation in a access reports....

    Thanks! for the solution posted over the net for auto serial number generation in a access reports. this solves my problem.
    KRISHNA.

  6. #6
    joy.academic is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2012
    Posts
    1
    Thanks Maximus! You solved my problem.

  7. #7
    Sooraj is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    1

    Awesome ............!

    Quote Originally Posted by maximus View Post
    put an unbound text box on the report. Go to its properties. In the control source put =1. Then in the Running Sum select over all. This will do the needful. Please mark the thread solved if this solves your problem.

    Thanks a lot ...!

  8. #8
    hnhpak is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Jan 2015
    Location
    Karachi Pakistan
    Posts
    28
    Thanks it is working in reports and helpful to me a lot. But it is not working in form as the property sheet does not have an option of running sum. Do you have any solution for this also?

    Thanks and regards

    Syed Haseeb ul Hasan

  9. #9
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    japab2009 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    2

    japab2009

    Quote Originally Posted by maximus View Post
    mark the thread solved my friend
    is it possible to start form other then 1 ?
    How can i start from 3,4,5,6.....?

  11. #11
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    For RunningSum in report? Not that I know of. If you use another number, it will increment by that value. Try it, see what happens.

    Can have another textbox with an expression that references the first textbox: =Text1 + 2

    Can hide the first textbox.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  12. #12
    japab2009 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    2
    Quote Originally Posted by June7 View Post
    For RunningSum in report? Not that I know of. If you use another number, it will increment by that value. Try it, see what happens.

    Can have another textbox with an expression that references the first textbox: =Text1 + 2

    Can hide the first textbox.
    Thanks for reply..
    yes i want to set a list in report.
    my out put should be.

    1 Index(label text) so not linked with and table query of report)
    2 Remarks (label text) so not linked with and table query of report)

    now below listed item and weight/qty from comes query.
    sr no....... item .......weight/qty
    3 ........apple ......5kg
    4......... banana... 8kg
    5 .........cat .........5 no.
    6 ..........dog .......3 no.

    so i want set 3 is my starting serial no in my report..

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

Similar Threads

  1. Automatic Report Generation - Access VBA
    By initiator in forum Programming
    Replies: 2
    Last Post: 04-19-2010, 05:10 AM
  2. Help On Creating Automatic of a Serial Number
    By lm_lopes in forum Programming
    Replies: 4
    Last Post: 03-10-2010, 06:47 AM
  3. Automatic Serial Numbers
    By Mitch87 in forum Access
    Replies: 9
    Last Post: 02-18-2010, 12:57 PM
  4. Auto Sequence String Serial Number
    By eddyc99 in forum Programming
    Replies: 2
    Last Post: 10-02-2009, 08:11 AM
  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