Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??

Duane Hookom wrote:
>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
>between each.
>
>BTW: I would never use this solution as it is prone to data entry errors and
>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..

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200601/1
.

Relevant Pages

  • ENTER MULTIPLE Items in a Query Pop-Up PROMPT e.g. [Name:]
    ... >The user running the query will be prompted for first names. ... Here's the SQL view of that query. ... The field that is being querried on is "route" ... Seperating each by a comma will not be a problem. ...
    (microsoft.public.access.queries)
  • Re: Using Text Box to Enter Criteria
    ... the "inefficient" solution because I could get it to work without any problem. ... I have created a form (frmReportCriteriaMenu) to select specific criteria ... be used in a query. ... under the Route field and it works great when I enter one route number. ...
    (microsoft.public.access.formscoding)
  • RE: Using Text Box to Enter Criteria
    ... The problem is not in the form or the text box, it is how the query is seeing ... When you put that in using one route, ... I have created a form (frmReportCriteriaMenu) to select specific criteria to ... under the Route field and it works great when I enter one route number. ...
    (microsoft.public.access.formscoding)
  • Follow up to earlier Select Query Question
    ... I wrote a query to pull out one unique route number along with the FirstOf ... fields from my original Route Info table using the suggested method below -- ... of equipment and the routes to which each piece was assigned -- let's call it ...
    (microsoft.public.access.queries)
  • Select statement security
    ... My DB users are USR1 and USR2 ... ALL the rows if the user running the above query is USR1 ...
    (microsoft.public.sqlserver.security)