Parameter Values prompted for twice

[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]

Post the SQL.

 

[Beth Barrie]

Post the SQL.

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:]));

 

[John Spencer]

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

 

[Access101]

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.

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

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

 

[Beth Barrie]

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.

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