| re: help with parameter value queries
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I'm assuming your problem is that you don't want the parameter box to
display twice, correct? If you had opened the query and then done a
sort or filter on the results and then saved/closed the query it will
"remember" it's last sort/filter state. Sometimes a sort/filter will
require the parameters anew. To fix this open the query, in results
view, & right-click & select Remove Sort/Filters, then close the
query. This may solve the problem.
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP8efDIechKqOuFEgEQKq+QCg8dIvYBuTqYiD3h1bEHHdbx d/JRIAn2NI
nqDee8Q2YlmjTpJ0T4LiFjwa
=ms11
-----END PGP SIGNATURE-----
Christine wrote:
[color=blue]
> I am struggling to learn to use Access almost on my own, and have
> written a query that needs to have a parameter. The query I wrote
> includes [Please enter facility code] in the Criteria of the design
> view, under the column that would contain the Facility Code. When I
> run the query, the 'enter parameter value' box comes up twice,
> rquiring the parameter to be entered twice before the information is
> displayed. I hope I'm explaining this correctly. Can someone direct me
> to a solution to this small problem? Thanks![/color]
| 
