Enter Parameter Value Dialog Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made a make table grouped by sums, & then am trying to use that table to
calculate the % of those sums. My issue is that when I try to run this
query, I get the "Enter Parameter Value" dialog box for one of my fields. I
don't want to enter a value, I just want the query to calculate. I've done
this before w/o this box appearing, so I'm not sure why it's happening this
time. Any clues how to get rid of this dialog box?
Thank you
 
Dear Mary:

You get this prompt when running a query when the query references
something it cannot find. If you didn't mean for this to happen, look
at the prompt it gives you. The specific prompt will tell you exactly
what it is that wasn't found. Look in your query's SQL for this
string.

Since this is referencing something that doesn't exist, but which you
apparently intended that it does exist, it must but misspelled or
mis-entered. Check this and change it. That is probably what you
need.

There are cases where Jet cannot handle a complex query, usually
involving nested subqueries, and will do this in error. If you're
having trouble finding the problem, post back here with the SQL of
your query and the string it prompt and I may be able to help further.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Mon, 22 Nov 2004 08:53:02 -0800, Mary A Perez <Mary A
 
Back
Top