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

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

Check that.....

I see the ">0" part is just part of the reply post format.

Using:

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

....then editing for my specfics gets a syntax error.

My actual situation concerns Route numbers (I used the Name example to try to
be as simple as possible).

The field is actually named "route" and could contain 200+ different possible
numbers.

So....using

WHERE Instr("," & [Enter Route Numbers] & ",", "," & [route] & ",")

gets a syntax error.

Could my edits be causing a problem?

THANKS

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Error *cannot return a value from method whose result type is void*
    ... he was getting one single compilation error on the first line. ... it was pointed out to him that the line contained a syntax error, ... The true error is the "missing return statement". ... look at the code in your method, and you'll see there is a route through ...
    (comp.lang.java.programmer)
  • 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: 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: CSWS v2.0 & CSWS_PHP v1.2 - "php4_module" error
    ... In a previous article, "Rick Barry" wrote: ... ->(The best route to ensure that a problem is addresses is to report it ... Syntax error on line 5 of /apache$root/conf/mod_php.conf: ... Can't locate API module structure `php4_module' in file /apache$root/000000/mo ...
    (comp.os.vms)
  • Re: SQL Join challenge
    ... > Here is the current cut and paste without editing. ... Same syntax error ... If you accidently call this code snipped twice ... 'Appraisers.FULLNAME AS AppraiserName, '#13#10+ ...
    (borland.public.delphi.database.ado)