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.
 
Your query is structured such that it is referecing the parameters twice.
 
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...
 
You must log in or register to reply here.

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

Similar Threads

Creating an update query that uses multiple parameters 2
why is parameter prompting twice? 1
Parameter Query Won't Run 0
HELP HELP!!!!! Access queries using parameters 1
Parameter query prompts twice 2
Combine Duplicates in Query 0
Parameter Queries in Crosstab Query 2
SQL RollUp SubQuery 2

Back
Top