Parameter Values prompted for twice

  • Thread starter Thread starter Beth Barrie
  • Start date Start date
B

Beth Barrie

I have built a query using two parameter values, one to check for the date
and one to check for what person to pull data for. When I run the query the
prompts all appear twice. Anyone know how to resolve this? The parameters I
am using in the Criteria line are Between [Enter the beginning date:] And
[Enter the ending date:] and [Enter Bookkeeper's last name:]

Thanks
 
KARL DEWEY said:
Post the SQL.
Click to expand...

Honestly, I am not advanced enough to have ever done any programming in
Access, but here is the SQL as requested. Thanks!

SELECT tblCTT.Date, tblCTT.[Practice#], tblClients.CompanyName,
Sum(tblCTT.[Approx Minutes]) AS [SumOfApprox Minutes], tblCTT.Bookkeeper
FROM tblCTT INNER JOIN tblClients ON (tblCTT.Bookkeeper =
tblClients.Bookkeeper) AND (tblCTT.[Practice#] = tblClients.[Practice#])
GROUP BY tblCTT.Date, tblCTT.[Practice#], tblClients.CompanyName,
tblCTT.Bookkeeper
HAVING (((tblCTT.Date) Between [Enter the beginning date:] And [Enter the
ending date:]) AND ((tblCTT.Bookkeeper)=[Enter Bookkeeper's last name:]));
 
Post the SQL of the query. (Hint on the menu VIEW: SQL)

Often you will get prompted twice if there is a minor misspelling of the
parameter.

If that is not the case, switch to SQL view, copy the SQL statement, and paste
it into a new query. Run the new query. IF you no longer get the prompts and
get the correct results, save the new version with the name of the old version.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
When I create the tables with fields as you have, the query params only show
up once.

There's a Return in one of the params, but it might have happened when you
copied it to this site.


John Spencer said:
Post the SQL of the query. (Hint on the menu VIEW: SQL)

Often you will get prompted twice if there is a minor misspelling of the
parameter.

If that is not the case, switch to SQL view, copy the SQL statement, and paste
it into a new query. Run the new query. IF you no longer get the prompts and
get the correct results, save the new version with the name of the old version.


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

Beth said:
I have built a query using two parameter values, one to check for the date
and one to check for what person to pull data for. When I run the query the
prompts all appear twice. Anyone know how to resolve this? The parameters I
am using in the Criteria line are Between [Enter the beginning date:] And
[Enter the ending date:] and [Enter Bookkeeper's last name:]

Thanks
Click to expand...
Click to expand...
 
John Spencer said:
If that is not the case, switch to SQL view, copy the SQL statement, and paste
it into a new query. Run the new query. IF you no longer get the prompts and
get the correct results, save the new version with the name of the old version.
Click to expand...

I tried this suggestion and it resolved the problem. Thanks so much for your
help!
 
Back
Top