MS Access asks for Parameter Value twice

[K. Georgiadis]

I have set up a query based on the following command,
where the "Cutoff Date" is required as a Parameter Value
for the query to run:

SELECT BIGLIST.Cust_id, BIGLIST.Company,
BIGLIST.Last_name
FROM BIGLIST
WHERE NOT EXISTS
(SELECT Cust_id FROM DONATION_DTL
WHERE DONATION_DTL.Cust_id = BIGLIST.Cust_id
AND CheckDate >= [Enter Cutoff Date]);

Everything was working fine except that suddenly Access
requires the parameter value to be entered TWICE before
it runs the query. Any ideas what may have caused this?

The only potential connection that I can think of is
that, at one point I was setting up a Report based on
this Query, but then decided to scrap the Report as being
redundant. I checked the SQL statement in the Query and
did not see any changes. I did run the report once and I
was required to enter the parameter value twice.

 

[Tom Wickerath]

In query design view, check Query > Parameters...
If you have a parameter entered, make sure that it is entered exactly as the parameter in
your criteria row. Verify that there are no leading spaces in a parameter entered in this
dialog.

If you copy the SQL statement and paste it into a new query, do you still receive two
prompts?

Tom
__________________________________________


I have set up a query based on the following command,
where the "Cutoff Date" is required as a Parameter Value
for the query to run:

SELECT BIGLIST.Cust_id, BIGLIST.Company,
BIGLIST.Last_name
FROM BIGLIST
WHERE NOT EXISTS
(SELECT Cust_id FROM DONATION_DTL
WHERE DONATION_DTL.Cust_id = BIGLIST.Cust_id
AND CheckDate >= [Enter Cutoff Date]);

Everything was working fine except that suddenly Access
requires the parameter value to be entered TWICE before
it runs the query. Any ideas what may have caused this?

The only potential connection that I can think of is
that, at one point I was setting up a Report based on
this Query, but then decided to scrap the Report as being
redundant. I checked the SQL statement in the Query and
did not see any changes. I did run the report once and I
was required to enter the parameter value twice.

 

[K. Georgiadis]

There is nothing entered in Query>Parameters. However,
this problem was solved thus: under closer inspection I
noticed that a change did occur in my SQL statement,
possibly during the process of setting up a Report based
on this Query. I reinstated the original SQL statement
and I'm back on track. Why the change occurred, I'll
probably never know

-----Original Message-----
In query design view, check Query > Parameters...
If you have a parameter entered, make sure that it is

entered exactly as the parameter in

your criteria row. Verify that there are no leading

spaces in a parameter entered in this

dialog.

If you copy the SQL statement and paste it into a new

query, do you still receive two

prompts?

Tom
__________________________________________


I have set up a query based on the following command,
where the "Cutoff Date" is required as a Parameter Value
for the query to run:

SELECT BIGLIST.Cust_id, BIGLIST.Company,
BIGLIST.Last_name
FROM BIGLIST
WHERE NOT EXISTS
(SELECT Cust_id FROM DONATION_DTL
WHERE DONATION_DTL.Cust_id = BIGLIST.Cust_id
AND CheckDate >= [Enter Cutoff Date]);

Everything was working fine except that suddenly Access
requires the parameter value to be entered TWICE before
it runs the query. Any ideas what may have caused this?

The only potential connection that I can think of is
that, at one point I was setting up a Report based on
this Query, but then decided to scrap the Report as being
redundant. I checked the SQL statement in the Query and
did not see any changes. I did run the report once and I
was required to enter the parameter value twice.


.