Getting prompted for parameters twice

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that is prompting me twice for parameters. The weird thing is,
it doesn't happen when I paste this into a new query.

But after I run it a couple of times and edit it, I get prompted twice. I've
checked the Parameters (Query -> Parameters) and there is nothing there.

Any idea what the problem is? The query returns the same result set for one
set of parameter prompts as when it with two.

SELECT tblProj.ProjName, tblFiscalCalendar.FiscalYear,
Sum(tblComponentDetail.HrsWorked) AS SumOfHrsWorked
FROM tblFiscalCalendar, tblProj INNER JOIN tblComponentDetail ON
tblProj.ProjID = tblComponentDetail.ProjID
WHERE (((tblFiscalCalendar.FiscalQtrNum) Between [Quarter Start] And
[Quarter End]) AND ((tblComponentDetail.DateWorked) Between
[tblFiscalCalendar].[FiscalStartDate] And
[tblFiscalCalendar].[FiscalEnddate]) AND
((tblFiscalCalendar.FiscalYear)=[Fiscal Year]))
GROUP BY tblProj.ProjName, tblFiscalCalendar.FiscalYear
ORDER BY tblProj.ProjName;

Thanks
 
hi,
i run into the same thing now and then. don't know what
causes it. I found that you don't have to make a new
query. Just delete the parameter save the query then
reenter the parameter.
yes. i know. it is aggrevating.
 
Did you run the query, then apply some sorting to the query, or a filter to the
query in the "table" view and then save the changes? This sometimes causes the
symptom you've observed.

If so, Open the query in datasheet view, click on Remove Filter/Sort and then
save the changes to the query format (layout). Now, try running the query again
and see if things are working correctly.
 
Back
Top