Parameter Query

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.
 
R

RH

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...
 
J

Jeff Boyce

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...
 

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

Auto Merge text from multiple sources 0
Amending meeting cancels all future meetings 0
Append Crosstab Query to Existing Table 0
Parameter Queries in Crosstab Query 2
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
between for paramter query for text 4
Parameters in Queries 2
Parameter Values prompted for twice 5

Top