Interested to Buy Any Domain ? << Click Here >> for more details...
. A database table called PERSON contains the fields NAME, BASIC and HRA. Write a computer program to print a report which employee name and total salary for those employees whose total salary is more than 10,000. Total Salary = BASIC + HRA. At the end, the program should also print the total number of employees whose total salary is more than 10,000.
- 1 Answers
- 6248 Views
- I also Faced
- E-Mail Answers
Answer / ibtu
Private Sub Form_Load()
02 rs.data source=" & App.Path & "PERSON.mdb"
03 rs.RecordSource = "select * from PERSON"
Dim CountEmp as Integer
CountEmp=0;
rs.MoveFirst
For i = 1 To rs.RecordCount ' Read all the records from database
Name = rs("NAME")
Basic = rs("BASIC")
HRA = rs("HRA")
TotalSal=Basic + Hra ‘Calculate the total salary
If TotalSal> 10000 Then
DISPLAY Name,Basic,Hra,TotalSal ‘Display employee
CountEmp=CountEmp+1 ‘Count the employees with sal >10000
End If
rs.MoveNext
Next i
DISPLAY “No of Employees”,CountEmp
End Sub
| Is This Answer Correct ? | 7 Yes | 1 No |
What are the characteristics of arrays in c?
What is typedf?
Tell me is null always defined as 0(zero)?
Is boolean a datatype in c?
what is the meaning of java that is (J A V A) full form of JAVA
71 Answers AKS University, Bhel, BNL, BPO, HCL, Peacecon,
1234554321 1234 4321 123 321 12 21 1 1 12 21 123 321 1234 4321 1234554321
sqrt(x+sqrt(x+sqrt(x+sqrt(x))))=2; Find the value of x?
write C code to reverse a string such that if i/p is "abc defg hij klmno pqrs tuv wxyz" and the o/p should be "cba gfed jih onmlk srqp vut zyxw"
Sir i need notes for structure,functions,pointers in c language can you help me please
‘ C’ PROGRAME TO SHOW THE TYPE OF TRANGLE BY ACCEPTING IT’S LENGTH .
What is Generic pointer? What is the purpose of Generic pointer? Where it is used?
Where static variables are stored in memory in c?
C 
