Re: QUESTION: MENU - NOT LIKE

[Frank Caruso]

** I think it is something like:

(Not $GROUP$ Like "%1;%" and Not $GROUP$ Like "1;%" and Not $GROUP$ Like "%; 1%")

You need to catch it as the first Group, anywhere in the middle and the last group

On 10/27/06, Tyrone Dee <[EMAIL PROTECTED]> wrote:

**

I have a Menu that shows all Users from the USER Form - no problem.

 

I would like to restrict all users who are Administrators from the pull down menu.  I tried:

 

NOT 'Group List' LIKE "%" + "1" + "%"

 

However, this is not working as there are other groups with "1" in the Group Number.

 

Any assistance would be greatly appreciated.

 

THANKS!

__20060125_______________________This posting was submitted with HTML in it___

--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___