data out of range

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

Guest

I am working with a multiple prompt query. My problem is an error that says
"ODBC-Data out of Range." My two prompts are [Enter ID] under the ID
criteria, and >=[Start Date] And <=[End Date] under the term criteria. I an
get rid of the error if I simply put [Enter Term] in its stead. This however
does not give me the range of data i require. Any help is appreciated.
 
Dear EESP:

ESP is what I do not seem to have.

You list 3 existing prompts, then say you replaced [Enter Term] in its
stead. In what's stead? All three? The pronoun "it" means ONE THING, not
3. So, what is it?

When does it say the error message? After you have entered the 3 prompted
items?

Please answer these things and post the SQL of your query. Perhaps someone
can then help.

Tom Ellison
 
Back
Top