Using an IIF statement in an Access Query, how can I check if a c.

From: SemperFi 1967 (1967_at_discussions.microsoft.com)
Date: 01/29/05 

Date: Sat, 29 Jan 2005 08:03:02 -0800

I have a text field that contains various messages for each record. Based on
a possible specific text sequence in that field, I want to perform a
calculation on another field. How can i use either a function that will look
to see if that part of the string is in there? My Query statement looks like
this: Adjustment Cost: IIF ([text field] contains "TKT Charge",
+10.00,). What is the function that would supplant "contains"? Any help
would be greatly appreciated.

Ken

Relevant Pages

  • Merry Christmas!
    ... dictionaries and every variant possibility has a separate "word" entry. ... The byte string of the "word", whose length is specified by a four ... match is found for a source byte sequence in the dictionary. ...
    (rec.arts.sf.written)
  • Merry Christmas! Linux RULES! New applications to develop!
    ... dictionaries and every variant possibility has a separate "word" ... Each entry in the dictionary contains: ... The byte string of the "word", whose length is specified by a four ... addresses whose entry is selected by the first byte of the sequence. ...
    (comp.os.linux.misc)
  • Re: user defined function that converts string to float
    ... > I need user defined function that converts string to float in c. ... initial, possibly empty, sequence of white-space characters (as ... point character, then an optional exponent part as defined in ... then a nonempty sequence of hexadecimal digits ...
    (comp.lang.c)
  • Re: Coin tossing guessing strategy...
    ... You need a precise string in exactly one order, ... with respect to sequences of n flips, is to note that if some sequence ... In fact, assuming a fair coin, all 10 coin sequences are equally ... heads and tails. ...
    (sci.math)
  • Re: Coin tossing guessing strategy...
    ... You need a precise string in exactly one order, ... with respect to sequences of n flips, is to note that if some sequence ... In fact, assuming a fair coin, all 10 coin sequences are equally ... heads and tails. ...
    (sci.math)