Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    157

    Unanswered: Problem in query

    Hi: Can any one please tell me why this condition dont work:
    DHGErrorOutlet.Outlets=[tbl_Events].[PPVVOD_Outlet]

    There is one outlet in DHGErrorOutlet and two in PPVVOD_Outlet on same ticketNum but it print two instead of print one

    SELECT tbl_PPVResearch.TicketNum, LastValidTech.Account1, tbl_Events.txt, LastValidTech.LstVldTech, tech_id.CORP, LastValidTech.ReportID
    FROM (DHGErrorOutlet INNER JOIN (((LastValidTech INNER JOIN tbl_PPVResearch ON LastValidTech.TicketNum = tbl_PPVResearch.TicketNum) INNER JOIN tbl_Events ON tbl_PPVResearch.TicketNum = tbl_Events.TicketNum) INNER JOIN tech_id ON LastValidTech.LstVldTech = tech_id.TECH) ON DHGErrorOutlet.TicketNum = tbl_PPVResearch.TicketNum) INNER JOIN tbl_ValidDisputes ON tbl_PPVResearch.TicketNum = tbl_ValidDisputes.TicketNum
    WHERE (((tech_id.CORP)=Val(Left([LastValidTech].[Account1],5))) AND ((LastValidTech.ReportID)="DHG") AND ((tbl_PPVResearch.Status)="Complete") AND ((DHGErrorOutlet.Outlets)=[tbl_Events].[PPVVOD_Outlet]))
    GROUP BY tbl_PPVResearch.TicketNum, LastValidTech.Account1, tbl_Events.txt, LastValidTech.LstVldTech, tech_id.CORP, LastValidTech.ReportID, DHGErrorOutlet.Outlets;

    Thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Why would it only print one if there's two entries in PPVOD_Outlet?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •