Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Fri, 13 Jan 2006 08:25:02 -0600
There were a couple recent threads (including yours) where I suggested
syntax like:
SELECT results.route
FROM results
WHERE Instr("," & [Enter Routes with comma between] & ",", "," & [Route] &
",")>0
ORDER BY results.route;
This should work if a user entered "6,13,27"
--
Duane Hookom
MS Access MVP
--
"kev100 via AccessMonster.com" <u16246@uwe> wrote in message
news:5a4c3038ca4e0@xxxxxx
> ** REPOST OF AN OLDER UNFINISHED THREAD **
>
>>The user running the query will be prompted for first names. They must be
>>entered exactly as stored in the first name field and must have a comma
> [quoted text clipped - 3 lines]
>>frustrations. I would create a form with a multi-select list box as
>>suggested by Tom Ellison very early in this thread.
>
> I agree as well, in most cases, however, in this particular application
> the
> "names" will actually be unique numbers between 1 and 3 digits long. A
> pull-
> down option would end up being just a giant list, hundreds of numbers
> long.
>
> Here's the SQL view of that query.
>
> SELECT results.route
> FROM results
> WHERE (((results.route)=[Route:]))
> ORDER BY results.route;
>
> The table name is "results"
>
> The field that is being querried on is "route"
>
> Currently, the user is prompted to enter the Route name (which is
> actually a
> number) they want to see all records for. However, they can only enter 1
> route at a time.
>
> They need to be able to enter 1 or More routes and have the query show all
> entered. Seperating each by a comma will not be a problem. Since route
> "names" are actually numbers, the chance of entry errors will hopefully be
> reduced..
.
- Follow-Ups:
- Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
- From: kev100 via AccessMonster.com
- Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
- From: kev100 via AccessMonster.com
- Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
- References:
- ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
- From: kev100 via AccessMonster.com
- ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
- Prev by Date: Re: Multiple IIF Statements
- Next by Date: Re: cursor follows mouse pointer
- Previous by thread: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
- Next by thread: Re: ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
- Index(es):
Relevant Pages
|
