All, I have this weird problem with my query. Sometimes when I run it the system asks me to input the criteria for the query twice, then sometimes is does not ask twice it works as expected.
here is my query. any pointers would be great.
The query is selected a number of values from another query depending on the Callstream and the Month of the year and uses a VBA function to calculate the result.
here is my query. any pointers would be great.
Code:
SELECT qryGet_CDS_Scores_No_Month.EIN, qryGet_CDS_Scores_No_Month.Month, tblSeller.CallStream, tblSeller.Forename, tblSeller.Surname, Scoreboard_Score([Adherance],"ADH") AS ADH_Score, Scoreboard_Score([CSCO],"CSCO") AS CSCO_Score, Scoreboard_Score([Compliance],"CompCSCO") AS ComplianceCSCO_Score, Scoreboard_Score([SPIPercent],"SPI") AS SPI_Score, IIf([PoorPerformance]=True,6,0) AS Poor_Per_Score, [ADH_Score]+[CSCO_Score]+[ComplianceCSCO_Score]+[SPI_Score]+[Poor_Per_Score] AS Score
FROM (qryGet_CDS_Scores_No_Month INNER JOIN qryMonthlySPIPercentage ON (qryGet_CDS_Scores_No_Month.EIN = qryMonthlySPIPercentage.EIN) AND (qryGet_CDS_Scores_No_Month.Month = qryMonthlySPIPercentage.Month)) INNER JOIN tblSeller ON qryGet_CDS_Scores_No_Month.EIN = tblSeller.EIN
WHERE (((qryGet_CDS_Scores_No_Month.Month)=[enter your month:]) AND ((tblSeller.CallStream)=[Enter Call stream:]));
The query is selected a number of values from another query depending on the Callstream and the Month of the year and uses a VBA function to calculate the result.