Click to See Complete Forum and Search --> : Datareport - with Record number


Anbuselvan
June 17th, 2001, 12:22 PM
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 anbuselvan_p@yahoo.com

pmmbala
June 17th, 2001, 11:41 PM
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.

pmmbala_old
June 17th, 2001, 11:41 PM
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.