Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Double Request For Imput

Status
Not open for further replies.

simeybt

Programmer
Nov 3, 2003
147
GB
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.

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top