Looks like i have done something wrong but don't know what and would appreciate if someone could help me here,
Employeefile Table containing Sr.No (Primary Key) Emp_Number And Emp_Name
Discrepancy Table cotnaining Emp_ID, Status, Discrepancy Type
Now when i created a query using both the tables and parameter as [Enter Employee Number] And Between [From Date] and [To Date] i am getting a mix response giving what is happening is when i enter employee number and date range in order to run a query i get the entry what i did but some information which is unders someone name is also showing in that employee and this confusing me. Can someone tell me what possible i have done wrong ?