why is parameter prompting twice?

[gator]

I have a parameter query in SQL as follows....

WHERE (((Transactions.TranDate)>=[Begin Date] And
(Transactions.TranDate)<=[End Date]));

When I run it it ask for Begin Date and then End Date and then Begin Date
and then End Date. It's asking twice. After I enter the parameters, twice,
it works. But why ask twice?

 

[gator]

I just copied SQL and pasted into new query...works.

 

[MGFoster]

I just copied SQL and pasted into new query...works.

I have a parameter query in SQL as follows....

WHERE (((Transactions.TranDate)>=[Begin Date] And
(Transactions.TranDate)<=[End Date]));

When I run it it ask for Begin Date and then End Date and then Begin Date
and then End Date. It's asking twice. After I enter the parameters, twice,
it works. But why ask twice?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It asks twice because one time you opened the query and sorted/filtered
the data, then you saved the query. When the query asked you if you
wanted to save the changes you'd made to the query (sorting/filtering)
you click the Yes button. Now when you run the query every time it hits
the sorting/filtering option you saved it asks you for the parameters
again.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSfC1+IechKqOuFEgEQKRjwCfTDxs/PGcqsu4PUZuV/knp1yYoz0AnRML
18h3jjvXTHK34kS57RYEg/3p
=V9nu
-----END PGP SIGNATURE-----