Access query prompts for the same parameter twice

T

Tim

In Access 2000 I create and save a query with a user parameter. At this
point the query runs fine.
Sometimes, not always, cannot figure out why, if I make a change in the
query (e.g. change the appearance order of two fields, or change the prompt
from entering a single date to a between start date and end date) the query
starts asking for the user prompt twice.
The first entry is ignored. If I enter different values every time the
prompt appears only the value from the second prompt is used in executing the
query.
A sample of the query on which this scenario occured, for both conditions
listed:
SELECT DISTINCT Table1.[Serv Nbr] AS [SO #], Table1.EquipID AS SN,
Table1.[Cust Nbr] AS [Customer #], Table1.[Cust Sortname] AS [Customer Name],
Table1.[Close Dt] AS [Closed Date], Table1.[Tech Sortname] AS [Tech Name],
Table1.[Problem Cd]
FROM Table1
WHERE (((Table1.[Closed Date]) Between [Start Date – m/d/yyyy] And [End Date
– m/d/yyyy]))
ORDER BY Table1.[Serv Nbr];
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top