Hi everyone. My Table it don have Field datatype autonumber. But in my Datareport i need it. For EX:
My Table Field in Database:
StudentID, StudentName, StudentSex...

My DataReport I need it to show like this
ID  StudentID   StudentName     StudentSex
1     S0001         Dara                   M
2     S0002         DaDa                  M
3     S0003         DaD                    F
4     S0004         DiDo                   F
5     S0005         DoDi                   M

I need your help. Can you help me out with this problem?  

____________________________
Please help out.

JUst a suggestion buddy. To become easier for you, why dont you add autonumber field in your database? Anyway, there are many ways on how to it. YOu can also get the record number of each record to serve as your ID in the dataREport.

rs.AbsolutePosistion

____________________________
Im JAMES  

JUst a suggestion buddy. To become easier for you, why dont you add autonumber field in your database? Anyway, there are many ways on how to it. YOu can also get the record number of each record to serve as your ID in the dataREport.

rs.AbsolutePosistion

____________________________
Im JAMES  

quote:

---

TJ_01 wrote:
JUst a suggestion buddy. To become easier for you, why dont you add autonumber field in your database? Anyway, there are many ways on how to it. YOu can also get the record number of each record to serve as your ID in the dataREport.

rs.AbsolutePosistion

---

TJ_01, can you tell me clearer about this? or tell me other way that possible please?
Looking forward to hearing from you.

____________________________
Please help out.

I just want to ask, what is the goal of autonumber or its functions in the datareport? If it is only for reference or unique id then i suggestion that you get the

Absolute.Posistion

of each record and display it in the report.

____________________________
Im JAMES  

I need auto number in data report like i say before.  
ID
1
2
3
4
5
this is display in data report. any more idea please?

[Edited by luckyboy on 16-09-2005 at 04:46 PM GMT]

____________________________
Please help out.

Well in my own idea, you can do looping that you assign a variable which increment everytime the record counts.

____________________________
Im JAMES  

I have a same problem. Ithink luckyboy just want to put an increment numbers only(Is that what U mean lucky boy?)

I also do not know how to put an increment number as TJ said do a record count ia a good idea but how to do that. Where to put the code?

____________________________
-fuji-

fuji_su, u are right. anyone help please not show increment number(autonumber)in form but in data report please please.

____________________________
Please help out.