Prompt Order

[Moxioron]

Below is SQL that works great, except the order that the operator is prompted to enter data.

Even though in the design view [# of Days in the Month] is at the end, the prompt is first.

I want [Start Date]And[End Date] to be first.....where am I going wrong? Thanks.

SELECT [tbl_Individual Return Performance Scorecard Data].Function, [tbl_Individual Return Performance Scorecard Data].UserID, [tbl_Returns Associates].[Associate Name], [tbl_Individual Return Performance Scorecard Data].Queue, [tbl_Individual Return Performance Scorecard Data].Volume, IIf(IsNull([Time]),0,[Time]/3600) AS Expr1, [tbl_Queus and SLAs].SLA, [# of Days in the Month] AS Expr2, [Volume]/[Expr1] AS Expr3, [Expr3]/[SLA] AS Expr4
FROM [tbl_Queus and SLAs] RIGHT JOIN ([tbl_Individual Return Performance Scorecard Data] LEFT JOIN [tbl_Returns Associates] ON [tbl_Individual Return Performance Scorecard Data].UserID = [tbl_Returns Associates].[User ID]) ON ([tbl_Queus and SLAs].[Queue Number] = [tbl_Individual Return Performance Scorecard Data].Queue) AND ([tbl_Queus and SLAs].Function = [tbl_Individual Return Performance Scorecard Data].Function)
WHERE ((([tbl_Individual Return Performance Scorecard Data].Date) Between [Start Date] And [End Date]))
GROUP BY [tbl_Individual Return Performance Scorecard Data].Function, [tbl_Individual Return Performance Scorecard Data].UserID, [tbl_Returns Associates].[Associate Name], [tbl_Individual Return Performance Scorecard Data].Queue, [tbl_Individual Return Performance Scorecard Data].Volume, [tbl_Queus and SLAs].SLA, [tbl_Individual Return Performance Scorecard Data].Time
HAVING ((([tbl_Individual Return Performance Scorecard Data].Function) Like [Function Name] & "*") AND (([tbl_Individual Return Performance Scorecard Data].UserID) Like [RACF] & "*"));

 

[boblarson]

.....where am I going wrong?

Not using an input form is where you are going wrong. Use a FORM.