Member Avatar for pardeep3dec

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.

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
  • 232 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by aktharshaik
Member Avatar for aktharshaik

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

Member Avatar for QVeen72

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

Member Avatar for aktharshaik

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.