Parameter Query

  • Thread starter Thread starter RH
  • Start date Start date
R

RH

Why is my parameter query asking for the same information (2) times.
Example: [Period Beginning] AND [Period Ending]. I have to input the
information twice to get an answer from the query.
 
It's working on my other queries. How can I change it to only ask the
question once? I currently have BETWEEN [PERIOD BEGINNING] AND [PERIOD
ENDING]?
Thanks, RH

Klatuu said:
Your query is structured such that it is referecing the parameters twice.
--
Dave Hargis, Microsoft Access MVP


RH said:
Why is my parameter query asking for the same information (2) times.
Example: [Period Beginning] AND [Period Ending]. I have to input the
information twice to get an answer from the query.
Click to expand...
Click to expand...
 
Post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Access MVP

RH said:
It's working on my other queries. How can I change it to only ask the
question once? I currently have BETWEEN [PERIOD BEGINNING] AND [PERIOD
ENDING]?
Thanks, RH

Klatuu said:
Your query is structured such that it is referecing the parameters twice.
--
Dave Hargis, Microsoft Access MVP


RH said:
Why is my parameter query asking for the same information (2) times.
Example: [Period Beginning] AND [Period Ending]. I have to input the
information twice to get an answer from the query.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top