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

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:] ??
    ... Also, you need to enter the list of names, separated by commas, and NO spaces. ... > board and not part of the criteria line that you suggested. ... > ...then editing for my specfics returns a syntax error. ...
    (microsoft.public.access.queries)
  • 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)
  • Re: between/and parameter help
    ... Try the following as criteria ... then post back with an explanation of what you mean by "doesn't work". ... You get the wrong results, you get a syntax error, you get some other error, etc. ... Access MVP 2002-2005, 2007-2009 ...
    (microsoft.public.access.queries)
  • Re: Between Dates on Query giving trouble
    ... I get a syntax error ... in the criteria for the SendOn field I have the following above. ... that criteria is there, the query/form won't work. ...
    (microsoft.public.access.queries)