Datareport - with Record number

[Anbuselvan]

Hi all,

How I can retrive the record number with records in Data Report. I have not any serial number fields.

MS-Access DataBase
-------------------------------------------------
SQL = "Select Name, Age from Students"
-------------------------------------------------

===============
S.No. Name Age
===============
1 Siva 30
2 Hari 25
3 Guna 35
: "" :
100 Ravi 40
===============

Pl's help me.

Regards

P.AnbuSelvan
Erode

Mail to [email protected]

[pmmbala]

Hi,

I think this is not possible in data report.if ur database is samll, better to create another table at run time with serial no field,other fields and display the contents in data report.