query

Sir, Kindly give answer for following question.

How to generate Serial Number automatically in Data Report without using Table.
we are not able to solve this problem in VB (6.0).
Please send the solution on e-mail ID [email protected]

Thanks in Advanace

Hello,

Kindly applu this SQL in Recordset,

Select rownum, ename, empno, sal from emp;

Table emp is having ename, empno, sal and rownum column is automatically used to store rownumber.

if your problem is not solved by this query reply me at:

[email protected]

i'll send u some other way to do this.