Hi,
I have a query that is returning inaccurate "Date Completed" results, please help! Here is the SQL:
PARAMETERS [Enter Start Date] Text ( 255 ), [Enter End Date] Text ( 255 );
SELECT DISTINCT [Qry BDM FA English Email Test Part 1].ADI_DISTRIBUTOR_ADVISOR, ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_DATE_COMPLETE D, [Qry BDM FA English Email Test Part 1].AGA_EMAIL, ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID, DateAdd("d",180,Date()) AS [Next Update], IIf([Next Update]<=[Next Update],"No","Yes") AS [Use in List?]
FROM ADL_LAN_LANGUAGE INNER JOIN ((ADL_AAH_ADVISOR_ACTIVITY_HISTORY INNER JOIN ([Qry BDM FA English Email Test Part 1] INNER JOIN ADL_AGA_AGENT_ADVISOR ON [Qry BDM FA English Email Test Part 1].AGA_EMAIL = ADL_AGA_AGENT_ADVISOR.AGA_EMAIL) ON ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_ADI_ID = ADL_AGA_AGENT_ADVISOR.AGA_ID) INNER JOIN ADL_CME_CONTACT_METHOD ON ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_CME_ID = ADL_CME_CONTACT_METHOD.CME_ID) ON ADL_LAN_LANGUAGE.LAN_ID = ADL_AGA_AGENT_ADVISOR.AGA_LAN_ID
WHERE (((ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_DATE_COMPL ETED) Between ([Enter Start Date]) And ([Enter End Date])) AND ((ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="28 1" Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="388 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="393 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="433 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="440 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="551 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="736 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="751 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="757 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="775 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="776 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="825 ") AND ((ADL_AGA_AGENT_ADVISOR.AGA_ACTIVE)="true") AND ((ADL_AGA_AGENT_ADVISOR.AGA_LAN_ID)="1") AND ((ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_CME_ID)="4" ) AND ((ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_AHS_ID)="6" ));
I have a query that is returning inaccurate "Date Completed" results, please help! Here is the SQL:
PARAMETERS [Enter Start Date] Text ( 255 ), [Enter End Date] Text ( 255 );
SELECT DISTINCT [Qry BDM FA English Email Test Part 1].ADI_DISTRIBUTOR_ADVISOR, ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_DATE_COMPLETE D, [Qry BDM FA English Email Test Part 1].AGA_EMAIL, ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID, DateAdd("d",180,Date()) AS [Next Update], IIf([Next Update]<=[Next Update],"No","Yes") AS [Use in List?]
FROM ADL_LAN_LANGUAGE INNER JOIN ((ADL_AAH_ADVISOR_ACTIVITY_HISTORY INNER JOIN ([Qry BDM FA English Email Test Part 1] INNER JOIN ADL_AGA_AGENT_ADVISOR ON [Qry BDM FA English Email Test Part 1].AGA_EMAIL = ADL_AGA_AGENT_ADVISOR.AGA_EMAIL) ON ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_ADI_ID = ADL_AGA_AGENT_ADVISOR.AGA_ID) INNER JOIN ADL_CME_CONTACT_METHOD ON ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_CME_ID = ADL_CME_CONTACT_METHOD.CME_ID) ON ADL_LAN_LANGUAGE.LAN_ID = ADL_AGA_AGENT_ADVISOR.AGA_LAN_ID
WHERE (((ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_DATE_COMPL ETED) Between ([Enter Start Date]) And ([Enter End Date])) AND ((ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="28 1" Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="388 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="393 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="433 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="440 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="551 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="736 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="751 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="757 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="775 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="776 " Or (ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID)="825 ") AND ((ADL_AGA_AGENT_ADVISOR.AGA_ACTIVE)="true") AND ((ADL_AGA_AGENT_ADVISOR.AGA_LAN_ID)="1") AND ((ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_CME_ID)="4" ) AND ((ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_AHS_ID)="6" ));
Select Query producing inaccurate results
