Hi Friends,
I have a Access table with S.No.,Name,Department,Status fields and some data attached with this mail.

when i used query "select * from emp where status='Yes';" and when i put textboxes named s.no. of command button of dataenvironment->connection1 then it always give there correspondence value i.e. only that record which status is Yes result s.no. will be 1,3,4,6,7,

but i want it continous serial no. 1,2,3,4,5,6,7,8,9,.................

Please help.

Dear,
I think the problem is with the field name.
Rename ur field name from s.no to sno

the period might be being treated as an operator. it may be implying that 's' is the table name and 'no' is the field name.
usually field names are referred with respect to their table name using the dot operator like

tablename.fieldname

Employee.Name
Employee.Age
Student.No
etc...

Hope this may solve ur problem


Regards
Shaik Akthar

Hi,

Inserting Serial Numbers in DataReport is a Tedious Process.. What you can do is , Insert all the Records in a Temp Table which has an Auo-Gen ID.. and Build report on that TempTable..
Such Things are easily done with Crystal Reports.. (any version)

Regards
Veena

u can create a variable and increment it at every line display.