View Full Version : i have a parameter problem....


davidperry1987
05-12-2005, 01:50 AM
ok, im new to access, so please bear with me!

i ma building a database for my boss, and everything was going somewhat smoothly until i got to parameters in my queries...

i have a date parameter in one query that reads, "enter date to view"

that worked fine, but now, whenever i make another query, even if it uses different parameters, when i run the query, the "enter date to view" appears, followed by the real paramater...

how do i correct this?!?!

thanks!

Mile-O
05-12-2005, 01:56 AM
Look under Query - > Parameters from the menu in the Query Design Grid. Anything?

Also, is the new query based on another that may be asking for the parameters?

davidperry1987
05-12-2005, 02:14 AM
i think that it was based on the original query... how can i check?

Mile-O
05-12-2005, 02:28 AM
Open the query up. Any tables and queries the query is based on appear atop the grid.

maxmangion
05-12-2005, 02:32 AM
if your query is built from the original query, then that's why you're getting the first parameter as well when you run your query.

So if you do not want to be asked for your first's query parameter, simply do not bind this query to it.