Parameter query

[Guest]

I have a query that asks for an employee ID, a start date and an end date as
parameters. The first few times it ran well, but then it began asking for
each parameter twice. I'm not sure what I did in between, but I can't stop it
now without rewriting the query. This is not the first time this has
happened. Does anyone know of an explanation for this?

Thanx,

Rip

 

[MGFoster]

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


You probably sorted or filtered the query when you had it opened &
clicked the "Yes" button when you closed the query (and didn't read the
"warning" that was displayed). Try this:

1. Run the query.
2. When the result set shows, right-click on a row & select Remove
Filter/Sort.
3. Close the query. When asked if you want to save the changes to the
query - click Yes.

That should get rid of the multiple parameter prompts. If not, I don't
know what caused your problem.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQZWEqYechKqOuFEgEQJBXACgy31QP6LT31EDh0ngX0K7doER+AwAoJ4V
0cFRvdYQUSGzvH9pyPT9qfLm
=51EU
-----END PGP SIGNATURE-----

 

[Guest]

Outstanding.

Thank you!

Rip

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


You probably sorted or filtered the query when you had it opened &
clicked the "Yes" button when you closed the query (and didn't read the
"warning" that was displayed). Try this:

1. Run the query.
2. When the result set shows, right-click on a row & select Remove
Filter/Sort.
3. Close the query. When asked if you want to save the changes to the
query - click Yes.

That should get rid of the multiple parameter prompts. If not, I don't
know what caused your problem.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQZWEqYechKqOuFEgEQJBXACgy31QP6LT31EDh0ngX0K7doER+AwAoJ4V
0cFRvdYQUSGzvH9pyPT9qfLm
=51EU
-----END PGP SIGNATURE-----