Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try without entering any spaces. I assume your users aren't actually
entering the quotes.

--
Duane Hookom
MS Access MVP
--

"kev100 via AccessMonster.com" <u16246@uwe> wrote in message
news:5a6a3b0977a0e@xxxxxx
> ** PLEASE IGNORE THAT FIRST REPLY TO YOUR POST.....THIS IS HOW IT SHOULD
> HAVE
> READ ***
>
> Thanks very much for that information.
>
> I did a direct copy and past of those query lines. It will run without
> errors, but produces an empty list.
>
> These lines from a Query that will can be used for a SINGLE route list....
>
> SELECT results.route
> FROM results
> WHERE (((results.route)=[Enter Route:]))
> ORDER BY results.route;
>
> ...work. For example, when run, the user can enter "50" at the prompt and
> it will return all the entries for route 50. And when run again, the user
> can enter "15" and it will return those entries.
>
> But when...
>
> SELECT results.route
> FROM results
> WHERE Instr("," & [Enter Routes with comma between] & ",","," & [Route] &
> ",")
>>0
> ORDER BY results.route;
>
> ....is used and the user enters "50, 15" only an empty lists results (a
> list
> with no entries).
>
> Have I mistyped something...or do I need to make any edits?
>
> Thanks very much for your help.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200601/1


.

Relevant Pages

  • Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
    ... These lines from a Query that will can be used for a SINGLE route list.... ... can enter "15" and it will return those entries. ... Duane Hookom wrote: ...
    (microsoft.public.access.queries)
  • Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
    ... These lines from a Query that will can be used for a SINGLE route list.... ... can enter "15" and it will return those entries. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Complicated Query
    ... able to get what you want by entering>0 on different ... >need to total this in this query. ... In the criteria for each ... >will not return any of the entries unless all 3 are ...
    (microsoft.public.access.queries)
  • Re: query wont return results
    ... record in that table before you can enter a related record in tblHoles. ... your data entry process first needs to focus on entering data ... Create a form that is based on a query that uses tblCourses as its data ... LinkChildFields properties of the subform control) where the subform is ...
    (microsoft.public.access.queries)
  • Re: Dlookup( One more thing...
    ... I tried entering in the expression you put down but is missing the Nz( ... last Dlookup statement which was pulling a value from the same report I ... trying to compare a value from my report to ... Each = A number value on my query ie: ...
    (microsoft.public.access.reports)