Parameter Query

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

 

[Klatuu]

Your query is structured such that it is referecing the parameters twice.

 

[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

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

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.

 

[Jeff Boyce]

Post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Access MVP

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

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

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.