0

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.

Attachments
S.no	Name	Department	Status
1	xyz	Admn		Yes
2	yzx	HR		No
3	jkl	Accounts	Yes
4	mno	Personnel	Yes
5	opi     Coke Oven	No
6	uyt     Power Plant  	Yes
7	ert	Admn		Yes
8	wer	Daybin		No
9	quw	Blast F		No
3
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by aktharshaik
0

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

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.