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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You do need the greater than zero.

WHERE Instr("," & [Enter first names] & ",", "," & [FirstNameField] & ",")>0

Also, you need to enter the list of names, separated by commas, and NO spaces.



"kev100 via AccessMonster.com" wrote:
>
> In my First reply, I suggested that one of the criteria lines I tried
> included the ">0" (in addition to a line without).
>
> I quickly realized that the ">0" was just part of posting a reply on the
> board and not part of the criteria line that you suggested. I just posted
> the second reply to let you know that I had realized that and that I was no
> longer including the ">0".
>
> So....eliminating the ">0" issue completely.....
>
> Copying and pasting the crteria line:
>
> WHERE Instr("," & [Enter first names] & ",", "," & [FirstNameField] & ",")
>
> ...then editing for my specfics returns a syntax error.
>
> The line I actually used after editing for my specifics is (name of the db
> field is "route"):
>
> WHERE Instr("," & [Enter Route Numbers] & ",", "," & [route] & ",")
>
> It too gets a syntax error.
>
> Could my edits be causing a problem?
>
> Thanks very much for the follow-ups
> KEV
>
> --
> 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 (e.g. [Name:] ??
    ... I suggested that one of the criteria lines I tried ... ....then editing for my specfics returns a syntax error. ... The line I actually used after editing for my specifics is (name of the db ... Could my edits be causing a problem? ...
    (microsoft.public.access.queries)
  • Re: Auto Playlist 1975-1985
    ... Click Add Criteria. ... You may have to reload media player for it to pick up the changes. ... to do the editing changes - though relatively easy to *break* the ...
    (microsoft.public.windowsmedia.player)
  • Finding missing syntax element
    ... the place you were last editing. ... at end of line syntax error at ./nms2.pl line 433, ... about global symbols which I use sort of poorly. ... the script ran `Strict' would find all the same stuff to holler about. ...
    (perl.beginners)
  • Re: Double join in SQL query - R:Base specific
    ... through the ODBC driver, and I prefer not to use an intermediate query ... in the database itself that I can call. ... WHERE a.x="some criteria" ... This gave me a "syntax error - 2367" when run through ODBC, ...
    (comp.databases)
  • RE: Multiple date parameters...simplify
    ... You got a syntax error in the Forms word, ... I'm not able to tab out of the criteria field (of my date ... > field in the query) w/ out receiving a syntax error message... ... >>> Steve ...
    (microsoft.public.access.forms)