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 ?
Discrepancy table is saving the SrNo value as the foreign key in Emp_ID field?
Should avoid special characters in names. Is there really a dot in Sr.No name?
Think will need to analyse project if you want to provide it.
To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!