query

[dinkar]

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 dinkar_chat@hotmail.com

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:

singh_vs@hotmail.com

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