Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Like* statement (2002 SP-2)

    Don't use =Like, but do it like this:
    <pre>=Abs(Sum([txtEquipmentType] Like "*Flatbed*"))
    </pre>


  2. #2
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Like* statement (2002 SP-2)

    I really should know how to do this, but it seems to escape me.
    =Abs(Sum([txtEquipmentType]="Flatbed")) returns all with "flatbed" in the txtEquipmentType of my continuous form, but what I want is all that contains flatbed. In other words "flatbed", "semiflatbed", "doubleflatbed". I've tried to incorporate a "Like" statement in here, but keep getting errors (ie. =Like "*" & "Flatbed" & "*"))
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Like* statement (2002 SP-2)

    Geesh, I was so close. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    I have now idea how you can remember when and when not to use " = " or any of the other inconsistencies (?), but I'm sure glad you do. Works perfectly.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •