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
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
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 Maximus....
It is woking....
Regards,
Jamil
mark the thread solved my friend
Thanks! for the solution posted over the net for auto serial number generation in a access reports. this solves my problem.
KRISHNA.
Thanks Maximus! You solved my problem.
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
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.
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.
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..