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

Thanks very much for that prompt. I think that will work great. However, I
did a copy and paste of:

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

....and edited for my specifics, but get a syntex error.

I also tried: WHERE Instr("," & [Enter first names] & ",", "," &
[FirstNameField] & ",")
....just in case that second line did not apply.


Also....The multi-selection suggestion would be neater, but there so MANY
different names that sorting through the choices would take more time that
just typing them in.


THANKS

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

Relevant Pages

  • Re: perl running question
    ... > as test.pl takes one argument, when typing test.pl, something like "please ... > provide your filename" should be printed at the prompt but it doesn't. ... Prev by Date: ...
    (comp.lang.perl.misc)
  • Re: Hes BAAAAACK!
    ... there butty ... > Sorry to prompt you into typing all those ... Prev by Date: ...
    (alt.vacation.las-vegas)
  • Re: Why does Word open but not respond to typing?
    ... but weirdly with a highlighting of all text and the ... vertical line that indicates where the typing takes place). ... Graham Mayor - Word MVP ... I hold "Esc" while clicking on the touchpad (for the prompt) - this ...
    (microsoft.public.word.docmanagement)
  • Re: NVidia from Livna seems to have broken X
    ... Not sure what you're doing by 'typing "3" at the prompt'. ... while in the GRUB boot menu screen). ...
    (Fedora)
  • Re: Auto saving
    ... webpages, because if I've been typing for a while, it must be time to hit ... in the habit of saving in just about every application. ... Since that prompt was a super annoying ...
    (microsoft.public.word.pagelayout)