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,.................