Query Filter

[juneau730]

I have a field in my dBase that contains the Active Directory Distinguished Name, that I need to filter on to separate account types. The data string in the field will look like this for a user account:

CN=Lapp\, Lawrence E. (Larry) (TUC) ISSO,OU=Users,OU=Tucson (TUC),OU=VISN18,DC=v18,DC=med,DC=va,DC=gov

And this for a service account:

CN=Admin\, Dental,OU=Service Accounts,OU=Tucson (TUC),OU=VISN18,DC=v18,DC=med,DC=va,DC=gov

I need to filter on either the word User or Service (bolded) so I can pull the different account type to their respective tabs. I have tried a like filter with a wild card parameter and that didn't work.

Any assistance would be great.

 

[Fazza]

I don't use Access really. So not sure if the wild card character is % or *

How about,

WHERE fieldname LIKE '%,OU=Users,%' OR fieldname LIKE '%,OU=Service Accounts,%'

and obviously if *
WHERE fieldname LIKE '*,OU=Users,*' OR fieldname LIKE '*,OU=Service Accounts,*'

 

[juneau730]

Good morning, thank you for the suggestion. After trying both strings you provided, unfortunately neither of them worked.

 

[xenou]

How exactly did you implement the use of this search criteria? (i.e., if in SQL, then what is the actual SQL that you used?)

 

[juneau730]

Score! I was able to get it working..

If I add the criteria filter in design view vice SQL view, the string would look like

Like "*Users*"

where the * is wildcards before and after the key word