Results 1 to 3 of 3

Query Mixup

  1. #1
    smarty84handsome is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    67

    Query Mixup

    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 ?

  2. #2
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    27,777
    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 if large - 2mb 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!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    smarty84handsome is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    67
    Great it worked for me

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums