Re: query against the user form group list field

[Rick Phillips]

Thad,

Thanks, what actually worked was:
('Group List' = ";20213;20000;") OR ('Group List' = ";20000;20213;")

Rick

On 4/1/2011 3:40 PM, Thad Esser wrote:

**
Rick,

You say ONLY those two groups, so that means the group list could only be one of two things:

('Group List' = "20213;20000;") OR ('Group List' = "20000;20213;")

Thad

On Fri, Apr 1, 2011 at 11:53 AM, Rick Phillips <r...@netfirst.com <mailto:r...@netfirst.com>> wrote:

    Happy Friday!

    I would like to search for all User form records where the group
    list is ONLY Service Request User and General Access.

    Service Request User  group id = 20213
    General Access group id = 20000

    I'm having problems with the advanced query.  Can anyone help?

    Thanks,

    Rick

    ARS 7.6.03
    SQL 2005

    
_______________________________________________________________________________
    UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
    <http://www.arslist.org/>
    attend wwrug11 www.wwrug.com <http://www.wwrug.com/> ARSList:
    "Where the Answers Are"

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"