Receiving 2 Pop-Up Boxes to enter Data

[MichelleM via AccessMonster.com]

I created a query to pull data based on Start Date and End Date parameters.
The query was working fine until a few days ago. When I run the query, I
receive the pop up for the Start Date, so I enter the Start Date, then I
receive the pop up for End Date, so I enter the End Date and then my data
would appear, but now, I receive the Start Date and End Date pop-ups a 2nd
time and then my data appears. I didn't make any changes, wondering if
anyone can look at my SQL View below and see if there is something wrong.

Thanks!

PARAMETERS [Start Date] DateTime, [End Date] DateTime;
SELECT tblAgents.[First Name], tblAgents.[Last Name], tblAgents.[Employee ID],
tbldbo_vw_Agent_Stats_New.AnsweredACDCallCount, tbldbo_vw_Agent_Stats_New.
DATEDT, tbldbo_vw_Agent_Stats_New.TrueFollowupTime, tblAgents.Dept
FROM tbldbo_vw_Agent_Stats_New INNER JOIN tblAgents ON
tbldbo_vw_Agent_Stats_New.CNAME = tblAgents.[Employee ID]
WHERE (((CDate([DATEDT]))>=[Start Date] And (CDate([DATEDT]))<=[End Date]))
GROUP BY tblAgents.[First Name], tblAgents.[Last Name], tblAgents.[Employee
ID], tbldbo_vw_Agent_Stats_New.AnsweredACDCallCount,
tbldbo_vw_Agent_Stats_New.DATEDT, tbldbo_vw_Agent_Stats_New.TrueFollowupTime,
tblAgents.Dept, tbldbo_vw_Agent_Stats_New.CNAME
HAVING (((tblAgents.Dept)="CCC"));

 

[John Spencer (MVP)]

AS a guess, you have a sort order that you set in the datasheet view. When
you do this, your query will actually run twice if you are using the datasheet
view of the query.

Open the query in datasheet view and use the menu to remove filter and sorts.
Menu: Records: Remove Filter/Sort.

Close the query and save the changes to the layout of the query.

Try running the query again and see if the problem disappears.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[MichelleM via AccessMonster.com]

That worked! Thank you so much!

AS a guess, you have a sort order that you set in the datasheet view. When
you do this, your query will actually run twice if you are using the datasheet
view of the query.

Open the query in datasheet view and use the menu to remove filter and sorts.
Menu: Records: Remove Filter/Sort.

Close the query and save the changes to the layout of the query.

Try running the query again and see if the problem disappears.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

I created a query to pull data based on Start Date and End Date parameters.
The query was working fine until a few days ago. When I run the query, I

[quoted text clipped - 18 lines]

tblAgents.Dept, tbldbo_vw_Agent_Stats_New.CNAME
HAVING (((tblAgents.Dept)="CCC"));